I cant get this to work, it comes back with run-time error '424': object required
I am using form controls option button not activeX controls. What do I need to do here?
HTML Code:
I cant get this to work, it comes back with run-time error '424': object required
I am using form controls option button not activeX controls. What do I need to do here?
HTML Code:
- Put this code in a standard code module like Module1 and not in a worksheet code module.
- In the code, change the names of the 3 option buttons to the same names of the form-type option buttons on your worksheet.
- Right-click on each of your three option buttons and assign this one macro to them.
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.
Thanks, but that is trying to run it. I just want to add in into my exicting macro at different points. I dont want it to to anything when I click it.
I want it to put "Alamo" in ("D14") if if option button12 is selected. I want this to run as part of a bigger macro. I just cant it to work though.
Try something like this...
Please Login or Register to view this content.
Awesome. Thanks for the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks