Highlight a Cell with VBA

[PaulFogel123]

I have a worksheet sample, attached. When you click the arrow symbol, it takes you to a cell and shades it in yellow. When I choose another cell elsewhere on the sheet, though, I want the highlighted cell to revert to "no fill." Can you help?
Thanks

 

[Hui]

Paul

Refer the attached file:

 

[PaulFogel123]

Thank you. I adapted your code to work in my file, like this:


It shades the selected cell all right, but when I click away, it does not clear the shade in AboutPtWeights. What am I doing wrong?

 

[Hui]

My file has code in the Sheet1 module
Did you see that ?

 

[PaulFogel123]

My file has code in the Sheet1 module
Did you see that ?

I did not see that. I looked at the code attached to the object (arrow).
Is this the code to use, not the assigned macro?



How do I assign this to an object?

 

[vletm]

PaulFogel123
I did not see that.
Try this way to see it:
1) Right click with mouse
2) select 'View Code'
3) ... then You'll see the code

 

[PaulFogel123]

I see both codes. One is assigned to the object (arrow) and the other in Sheet1 module. My questions above about which one to use and how to assign it to a new object in another workbook still remain.

 

[Hui]

Paul

the 2 macros work together with the global variable

 

[PaulFogel123]

Hey, it works! Thanks, Hui

 

[PaulFogel123]

Wait--I did run into one problem. It only works if I don't have protection enabled. I put enable protection into the module macro:



And this works fine. But when I select another cell (move away from AboutPatientWeights), it triggers an error in the Sheet code:



How can I fix this?

 

[Hui]

Can you please attach the file?

 

[PaulFogel123]

It's attached. The object, in this case, is Patient Weights at the top of the sheet. If you protect the sheet, it triggers an error. Otherwise, it works just as you designed it. Thanks so much.