Loop Statement : Use of string to refer userform object

Greetings,

In my userform I have several frames (Frames 2-6) that are enabled as per the optionbutton selection (enclosed in Frame1). By default the frames (2-6) are disabled. I tried to write a code where if the optionbutton selection changes any frames that have been previously enabled should be disabled before enabling the frame for the current optionbutton selection.

I approached the problem by first identifying the name of the enabled frame using the below procedure.

Please Login or Register  to view this content.

The correct frame name is returned irrespective of the order in which I click the optionbuttons. However when I add the line

Please Login or Register  to view this content.

after the msgbox statement, the correct frame name is returned & hence the enabling takes place only if I click the optionbuttons in ascending order, ie, 1, 2, 5 etc. If I click optionbutton2 after clicking 5, the message box returns frame6 (corresponding to optionbutton5) with frame6 enabled. Frame3 (corresponding to optionbutton2) does not get enabled.

Why is this happening? Please help.
Asha

N.B. Frame1 also has a combobox and textbox whose values will not change with a change in optionbutton selection.

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

your code will return the name of the last frame that was enabled.

if more than 1 frame was enabled only the last one is stored.

Why don't you link a checkbox to each specific frame ?

Please Login or Register  to view this content.

If you want only 1 frame enabled at the time you can use optionbuttons

Please Login or Register  to view this content.

Thanks for your response royUK.

As recommended I have attached two sample files.

SampleTestUserform - does not contain the statement

Please Login or Register  to view this content.

SampleTestUserform2 contains this statement. The code will return the correct frame number and enable the correct frame as long as the optiionbuttons are clicked in ascending order.

My question is if the messagebox can return the correct name, why will the enabled function not work in the same manner when both are referencing the same variable, ie sFraName.

Thanks
Asha

Disable all frames then set the one associated with the option

Please Login or Register  to view this content.