Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default create dialog box within macro and use value chosen

I am creating a macro in excel 2002. In the macro I would like to
create a dropdown box that users choose a value from and then do
different things depending on what they choose.

Can this be done and can anyone point me in the right direction ?

Thanks
Paul Trower
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default create dialog box within macro and use value chosen

Check out this sleek macro for listboxes. I used it in my spreadshee
and it works great!


http://www.lacher.com/#Free%20Excel%20Example

--
Message posted from http://www.ExcelForum.com

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default create dialog box within macro and use value chosen

thanks for the message but I don't want to buy something

all i want to know is how to invoke a listbox in a macro and how to
grab the choice made

thanks
paul
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
Macro preparing numbers to be booked (columns to be chosen conditionally) markx Excel Worksheet Functions 0 May 23rd 06 03:11 PM
Create a dialog box Raza Excel Worksheet Functions 3 December 2nd 05 06:34 PM
Create Startup Dialog coal_miner Excel Discussion (Misc queries) 2 June 8th 05 07:25 PM
control of dialog macro dialog box. on open Gerry Abbott Excel Programming 0 July 22nd 04 05:41 PM
Create a Dialog Box Chas Excel Programming 3 May 3rd 04 03:22 PM


All times are GMT +1. The time now is 01:08 AM.

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"