Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default VB style drop down menu on an excel user form?? help

can any one tell me how you can add a drop down menu live in VB
to an Excel user Form.

it does look there is any way.

thanks

--
Ray


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default VB style drop down menu on an excel user form?? help

Hi Ray.

'----------------
can any one tell me how you can add a drop down menu live in VB
to an Excel user Form.

it does look there is any way.
'----------------

Commandbars are not supported in Userforms.

Perhaps you could create a deopdown menu with
one, or more, Userform controls.


---
Regards,
Norman


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9,101
Default VB style drop down menu on an excel user form?? help

this is better done with a listbox which is pretty easy to do in VBA on a
userform. You can have the list box or form hidden until it is needed,
doesn't have to be LIVE.

"Ray" wrote:

can any one tell me how you can add a drop down menu live in VB
to an Excel user Form.

it does look there is any way.

thanks

--
Ray



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
Trying to get a User Form to activate off a drop down menu Rcarper Excel Discussion (Misc queries) 2 October 2nd 09 02:04 PM
How to invoke a user form from a custom button on the menu bar JLGWhiz Excel Programming 0 January 20th 07 03:32 AM
link to pdf file & menu bar in user form Fendic Excel Programming 2 June 2nd 05 08:31 PM
Use a simple Drop Down List or User Form Ted Excel Programming 0 October 11th 04 09:37 PM
Data Input - User Form Drop-Down Box meflorence[_3_] Excel Programming 2 May 18th 04 02:43 PM


All times are GMT +1. The time now is 06:36 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"