Loop through userform frame controls

**c00ly81** · 05-12-2016, 03:43 AM

Hi

I have a userform with multiple optionbuttons in a frame. When i launch the userform i want the value og the optionbox that has the same caption as cell A2 in worksheet "Enhet", to be TRUE. Hope I explained it OK. I have tried the code below. But I have never tried this before, så it may be way of...

Please Login or Register  to view this content.

**pike** · 05-12-2016, 03:45 AM

depends but basically

Please Login or Register  to view this content.

expanded

Please Login or Register  to view this content.

**pike** · 05-12-2016, 03:56 AM

or

Please Login or Register  to view this content.

**c00ly81** · 05-12-2016, 04:19 AM

Originally Posted by pike

or

Please Login or Register  to view this content.

Perfect! Thank you so much!!

**pike** · 05-12-2016, 04:38 AM

Hello
you can check the checkbox with Boolean value to remove one if statement from the sub routine
eg...

Please Login or Register  to view this content.

Loop through userform frame controls

LinkBack

Thread Tools

Rate This Thread

Display

Loop through userform frame controls

Re: Loop through userform frame controls

Re: Loop through userform frame controls

Re: Loop through userform frame controls

Re: Loop through userform frame controls

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Looping through controls by frame on userform (frame within a frame)

[SOLVED] adapt userform loop using control name containing variable for worksheet activex controls

[SOLVED] loop using references to controls in userform values

[SOLVED] userForm -> Frame 'top' value limited. Dynamically created controls,

loop controls in userform except one textbox

Loop through controls in UserForm

Creating Userform Controls on Frame

Bookmarks

Bookmarks

Posting Permissions