Dimitris254
Board Regular
- Joined
- Apr 25, 2016
- Messages
- 139
I'm looking to create a user-friendly interface (GUI - if 3 buttons qualify for GUI
), nothing fancy, just a simple box with 3 options to select:
I'm planning to have this box embedded into the only worksheet the user will see (the rest will be very hidden).
So... how do i do this?
I have seen Form and ActiveX controls, but how will my macro read what option is selected? Is there a variable attached to each button?
Also these Form/ActiveX control are put onto the worksheet, i was thinking of something like a Message Box style (if i can color the background etc even better).
If you could direct me to sites with samples, that would be very helpful too.

- USD or EUR
- both or latest
- new report or update existing
I'm planning to have this box embedded into the only worksheet the user will see (the rest will be very hidden).
So... how do i do this?

I have seen Form and ActiveX controls, but how will my macro read what option is selected? Is there a variable attached to each button?
Also these Form/ActiveX control are put onto the worksheet, i was thinking of something like a Message Box style (if i can color the background etc even better).
If you could direct me to sites with samples, that would be very helpful too.
Last edited: