Macro Recording - Macro Button - Option Button Groups

[jwpardo]

I have been recording macros on a sheet. They are very simple, however, two of them are not doing what I need them to do.

CASE 1
I have created several groups of option buttons. In one group I have something similar to the following:

GROUP BOX 125
option button 1 (If selected returns "not applicable" to a cell, otherwise " ")
option button 2( if selected returns "$100")
option button 3 (if selected returns "$200")

Situation 1:
I created a Macro button and macro, however, it is not executing the selection of the option button. Is this normal?

The Intent 1:
In group box 125, if the project does not require the price adder, I want a macro to select "option button one". I positioned the macro button for this command near the beginning of the section. When I click on the macro button, the desired button is not checked. How do I solve this problem?


Case 2:
I created a macro to take the user from the end of one section to the beginning of another. I did this by recording the commands to scroll down from the existing location to the start of the new location. The macro does work, but it does not always take me the beginning of the section. What I envision is having the desired target cell located at the top left hand corner at the top of the screen.

Any thoughts,

Thanks,
James Pardo
jpardo@nbe-inc.com

 

[TryingToLearn]

Helpful if you posted the code of the macro that is not performing the selection you want.

1:

Would suggest inserting something along the lines of the following into your macro where you need it:

if  (determination criteria of the project does not require the price adder) then  OptionButton1 = True

2:

My experience in doing similar functions has led me to do all selections relative to A1 so for example if I want the sheet to be on D25 my code will be

Range("a1").Select
Range("D25").select


HTH