Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Conor
 
Posts: n/a
Default offer dropdown options based on another dropdown


All,

This is for a single worksheet within a single workbook. The worksheet
needs to have 2 dropdown boxes.

I want users to select themselves from dropdown box #1.

I want to populate the list of choices within dropdown box #2 based on
who is signed in.

I am sure VBA will be required, but probably not too daunting. I just
can't get it. Thanks in advance.

Conor


--
Conor
------------------------------------------------------------------------
Conor's Profile: http://www.excelforum.com/member.php...o&userid=30450
View this thread: http://www.excelforum.com/showthread...hreadid=501120

  #2   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default offer dropdown options based on another dropdown

Hi

Have a look he
http://www.contextures.com/xlDataVal02.html

Andy.

"Conor" wrote in
message ...

All,

This is for a single worksheet within a single workbook. The worksheet
needs to have 2 dropdown boxes.

I want users to select themselves from dropdown box #1.

I want to populate the list of choices within dropdown box #2 based on
who is signed in.

I am sure VBA will be required, but probably not too daunting. I just
can't get it. Thanks in advance.

Conor


--
Conor
------------------------------------------------------------------------
Conor's Profile:
http://www.excelforum.com/member.php...o&userid=30450
View this thread: http://www.excelforum.com/showthread...hreadid=501120



  #3   Report Post  
Posted to microsoft.public.excel.misc
Conor
 
Posts: n/a
Default offer dropdown options based on another dropdown


I've only skimmed it so far, but it looks like this will do the job.
Thanks. You're the man.


--
Conor
------------------------------------------------------------------------
Conor's Profile: http://www.excelforum.com/member.php...o&userid=30450
View this thread: http://www.excelforum.com/showthread...hreadid=501120

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
How do I offer ChartType options? davidm Charts and Charting in Excel 4 December 29th 05 02:13 PM
Format from menu will not offer options or choices? Tribeventure Excel Discussion (Misc queries) 0 December 6th 05 08:16 PM
How do I set Save Options? DeweyG Excel Discussion (Misc queries) 1 September 14th 05 01:35 AM


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