Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 747
Default Msgbox to make a choice

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
web browser choice? Roger on Excel Excel Discussion (Misc queries) 1 February 5th 10 04:42 AM
Choice of Formula Naraine Ramkirath Excel Worksheet Functions 4 June 28th 07 09:29 PM
How do I allow users to make a choice in a worksheet? Jim Zavone Excel Worksheet Functions 2 June 23rd 05 12:09 PM
Is IF the best choice br0ke Excel Worksheet Functions 2 January 26th 05 02:19 PM
the best candidate gets its first choice Martyn Wilson Excel Programming 4 July 7th 04 02:27 AM


All times are GMT +1. The time now is 01:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"