I have the following macro run when I click on a button.
I would like when i click on the button for it to highlight those cells to inform the agent which cells need to have data in it and if it is all filled out properly then run this macro. Any help would be greatly appreciated - I have included my workbook for any assistance you can provide!
Please Login or Register to view this content.
You could just use Conditional Formatting. Select one of the required cells and use this CF rule
Cell Value is equal to =""
It will be highlighted when empty and not highlighted when filled.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
That will not work as for each button it could require some of the same cells - basically I want to keep the cells white and when the click on the button to run the macro, I want it to highlight the fields that are required for that macro to run properly!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks