Solved How to format a cell in Excel 2010 when selected

January 5, 2014 at 08:41:04
Specs: Windows 7
I am going to use a macro with relative references to copy a range of cells from one workbook to another. As such the user must be in a specific cell to capture all the data the second worksheet will need. I'd like for specific cells to change text color when they are selected to indicate the user is at the correct location to run the macro. Any thoughts? I can't seem to do it with conditional formatting. Any and all ideas would be greatly appreciated!

message edited by mrgrogro


See More: How to format a cell in Excel 2010 when selected

Report •

#1
January 5, 2014 at 14:15:46
✔ Best Answer
My Macro skills are just above nil,
but it would seem that the easiest way
to being your Macro would be to send the user it to your Start Cell first,
then no matter where on the spreadsheet the user is, he is always goes to the correct cell, before anything else occurs.

MIKE

http://www.skeptic.com/


Report •

#2
January 5, 2014 at 14:59:10
Thanks, Mike. I really appreciate the response. Unfortunately, the workbook is a series of "recipes" with scores of combinations and is getting bigger and bigger. It requires the end user to choose the recipe they feel is best suited based on the inventory they have available. Because there are so many possibilities, I was hoping to find a feature similar to the gotfocus property available in Access. If nothing exists, that's okay. I was looking a "bells and whistles" anyway. Again, thanks for responding. Folks like you have alleviated many an excel headache on previous projects!

Kevin


Report •

#3
January 5, 2014 at 15:10:27
Sorry I can't offer more substantial help, hopefully someone with more in depth knowledge will offer some direction.

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
January 5, 2014 at 17:17:39
There is a Worksheet_SelectionChange macro that will fire when a cell or range is selected. We would need some more specific details before any actual Cade can be offered.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#5
January 5, 2014 at 18:30:47
I currently have a worksheet named "Recipes". On it I currently have unnamed ranges of cells that are four columns wide and seven rows high. These groups currently extend 15 groups across and 16 groups down. Each has a unique recipe. The uppermost left hand cell in each group contains the name of the product described in the subsequent 6 rows. I can record and modify a macro to select the range and copy it to another worksheet named "Schedule" I was just hoping to identify the cell containing the name of the product (or the entire range) by changing the font or background color before initiating the macro. It isn't really important it is just that the people that will be using this tool aren't very computer literate so when I'm done, it has to be easy-breezy and locked down lest I come in one day to find the workbook rendered useless.

Report •

#6
January 6, 2014 at 13:35:35
I'm not really sure what you are asking for.

What is the reason to "identify the cell containing the name of the product (or the entire range) by changing the font or background color before initiating the macro"?

I don't see how "identifying" the range by changing the fill color, etc. will prevent the workbook from being rendered useless.

I guess I need some more details as to the process your users will be using and what you are expecting this "range indentification" to accomplish.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Ask Question