Popup to the right of an active cell

bowemc
bowemc used Ask the Experts™
on
Hi

I'm using Excel 2007. I've a s/s my application users complete and email when they wish to onboard a new user.

I was looking at https://signup.bigfilebox.com/signup and like how when a user clicks on a field the cell border changes. Also for some fields (login name) a blue pop up appears with a verbose explanation

I was wondering how can I do both of these in Excel? (1) for defined cells, if they are active the border changes to a colour i've defined and (2) if certain fields are selected a pop-up appears to the right of the cell with a text destruction. It needs to be a pop-up as the cell(s) to the right may be populated by other things. It disappears as soon as the cell looses focus

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Adding a popup is easy; just put something in the cell's 'Comment' property.

Here's a link to a thread that shows how to do the borders.
Most Valuable Expert 2011
Top Expert 2011

Commented:
You can also use Data Validation for the comments - it's one of its purposes in life. ;)

Author

Commented:
rorya - how do i do this?
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
In Excel 2010 it's Data->Data Validation from the ribbon menu.
Most Valuable Expert 2011
Top Expert 2011
Commented:
Same in 2007 too. Set the Input message to whatever text you want.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial