Hi All,
I'm looking into some way to bring up a message box with a clickable hyperlink to a file or folder when a specific checkbox is ticked.
Is this possible?
something like this:
Please Login or Register to view this content.
Hi All,
I'm looking into some way to bring up a message box with a clickable hyperlink to a file or folder when a specific checkbox is ticked.
Is this possible?
something like this:
Please Login or Register to view this content.
Last edited by Gti182; 05-12-2017 at 11:04 AM.
Hi Gti182
This can sort you out...Need a userform created though.
http://stackoverflow.com/questions/2...n-a-messagebox
Edited:
https://blogs.technet.microsoft.com/...a-message-box/
Last edited by sintek; 05-12-2017 at 06:45 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Thanks sintek, had a look but want to avoid going down this route as i've already got form checkboxes setup in my sheet.
found an alternate solution which works by opening a folder location when yes is clicked on the message box, code below.
Trouble now is i'm struggling to active this macro automatically when the checkbox is clicked.
Please Login or Register to view this content.
Upload a sample file so that we can have a look...
Edited:
Try this
Please Login or Register to view this content.
Last edited by sintek; 05-12-2017 at 09:50 AM.
Hi Sintek, not sure this triggers when the checkbox is checked?
edit: if I check the checkbox and manually run the macro it works perfectly
Last edited by Gti182; 05-12-2017 at 10:10 AM.
Upload a sample file so that we can have a look...
file attached, tick checkbox should bring up the message box
Hi GTi182
You would have to assign the macro to the CheckBox...See uploaded sample
that works a treat, thanks sintek
pleasure...thanks for rep point. Please mark thread as solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks