LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,236
Default have a "drop down menu" appear in a data form

You could do it by code:

eg.
Private Sub UserForm_Initialize()
ComboBox1.AddItem "First Item"
ComboBox1.AddItem "Second Item"
ComboBox1.AddItem "Third Item"
ComboBox1.AddItem "Fourth Item"
'...
End Sub

Or you could set the RowSource proeprty of the Combo to an Excel Range.
eg.
Sheet1!A1:A12


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Jeff Johnston" wrote in message
...
Need some help. I have a data form that appears when an
employee runs a macro. In one of the cells I want the
user to select from a drop down menu. I only want 12
possible "text entries" (choices) that can be selected.
Is this possible?



 
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
Drop-down list on simple excel 2003 form using "form" from data me S Beals Excel Discussion (Misc queries) 0 March 2nd 10 08:35 PM
DROP DOWN MENU "source" Kanmi Excel Worksheet Functions 5 September 28th 09 08:32 PM
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F daves Excel Discussion (Misc queries) 3 April 24th 07 04:52 AM
how to hide "All" in drop-down menu of my pivot table nader Excel Discussion (Misc queries) 0 January 26th 07 12:17 AM
if "a" selected from dropdown menu then show "K" in other cell LEGALMATTERS Excel Worksheet Functions 1 April 13th 06 06:05 PM


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