Hi, I'm very new to VBA and on one sheet am trying to run a macro to open a calendar when a particular cell is selected, I've managed to do this for one cell, but cannot find a way to run the same macro on a second cell selection within the same sheet. Is this possible?
This is what I have so far:
Please Login or Register to view this content.
Hi Welcome to the forum
Currently your macro will run if you select any cell in the range I25:M25. What do you mean by a your second selection?
Regards,
Rudi
Use a comma instead of a colon to separate the non-contiguous cells.
Please Login or Register to view this content.
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.
If AlphaFrog has analysed your request correctly, you can also use the Union function.
Please Login or Register to view this content.
Thanks RudiS & AlphaFrog, both work and have resolved the issue I was having.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks