Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Michele,
The technique I gave you creates on-the-fly a UF and then deletes it. It doesn't have to be done this way. The UF can be made permanent and the option buttons (OB's) can be added at run time. The command buttons can be positioned to accomodate the number of OB's and the UF sized to suit. Alternatively, the maximum number of OB's that would ever be required can be added at design time and made invisible. The number required would then be made visible at run time. I think this would get around the problem you describe. If you decide that you want to try this, I think you should start another post as this one is rather old. Best regards, Greg " wrote: Hi Greg, Got it! And it works great! It copied funny and I ended up with some returns where they weren't supposed to be. There is a small error (runtime error '424' Object required) that sometimes comes up at line 'VBA.UserForms.Add(UF.Name).Show' which is the 2nd last line. It comes up when I've already run the macro and run it again when the CSQuoteForm. xls is still open. But, then if I run it a third time, it works okay and says the file is open and quits. I can't thank you enough. There is still hope for humanity when kind people like you exist. Thanks, Michele |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
web browser choice? | Excel Discussion (Misc queries) | |||
Choice of Formula | Excel Worksheet Functions | |||
How do I allow users to make a choice in a worksheet? | Excel Worksheet Functions | |||
Is IF the best choice | Excel Worksheet Functions | |||
the best candidate gets its first choice | Excel Programming |