LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Regnab
 
Posts: n/a
Default Entering Values into Combobox in Spreadsheet

I'm trying to place a combobox on a spreadsheet and then enter values
into it manually for the user to choose (specifically the months in a
year). I'm been through the forums and found instructions to go to
format control and properties and add it there. However, the only
option available to me in properties is object positioning. There is
nothing there about adding values. The only other way I can think it
would be possible is to add it to code which runs when the workbook
opens (an example would be helpful) but if there is a simplier way, I'd
much rather use it.

Thanks

Reg

 
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
Spreadsheet Security Lee Meadowcroft Excel Discussion (Misc queries) 0 April 6th 06 09:40 PM
entering new data in a saved spreadsheet without losing formulas? Jackie in Houston New Users to Excel 1 January 31st 06 01:00 AM
How do I protect the cell from users entering values in Excel? Prasad NS Excel Worksheet Functions 1 January 12th 06 11:17 AM
Need step by step for entering data into combobox mandy Excel Discussion (Misc queries) 2 December 7th 05 03:37 PM
Second serie doesn't use X-as values JackRnl Charts and Charting in Excel 1 January 20th 05 01:04 AM


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