Hi All

I'm relatively new to VBA.

I have designed a UserForm for other people to use and have used VBA to hide Excel, before loading the form, as some of the users "don't like it".

If I use the close button, I can reshow Excel, but if I need to edit the form, and Ctrl+Break, Excel goes and I cannot easily restart the same file.

Any suggestions for this, please?

With Excel hidden, the UserForm is larger than the screen. I do not have the slider to move up and down the form, and tabbing through boxes takes the cursor into the bottom half of the form (the part that is offscreen), but does not allow the user to know what is being asked.

Finally, there are several option buttons with separate Group Names. How can I find out which option button is selected? I've used a naming convention OptButton1, OptButton2, etc., and would like to have optButton1 = value of 1, optButton2 = value of 2, etc.

i have found a website that would necessitate a looping routine listing each button in turn, but as one group has 16 options, I was hoping to programme it such that I look through the group name and identify which option in each group has a TRUE value.

Any help would be gratefully appreciated.

Thanks in advance.