LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default User Form

OK, a newbie at UserForms in Excel. I want to make 2 combo boxes in Excel.
One has a named range which uses the data from the worksheet, which I
figured out, but when an item is chosen in the first combo, I want it to
requery and have a new list of items. What do I do to make this happen.

If Column 1 has Value1, Value2 in the data, then the 1st combo fills with
Value1 and Value2. Also, Column1 in the worksheet looks like this:
Column1
Value1
Value2

Then I have in Columns 2 and 3 the following, which I think I have to do to
represent what data to use for the 2nd combo.
Column2 Column3
Value1 A
Value1 B
Value1 C
Value2 AA
Value2 BB
Value2 CC

So how do I choose Value1 in the first combo (which reads from Column1), and
then have it show A,B,C in the 2nd combo?



 
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
Call user form from ThisWorkbook; close file if form closed XP Excel Programming 2 July 20th 07 07:04 PM
Automatically add a textbox to a user form based on user requireme Brite Excel Programming 4 April 7th 07 11:37 PM
User form ComboBox Items: Remember user entries? [email protected] Excel Programming 0 March 29th 07 06:41 PM
How to: User Form to assign a user defined range to a macro variab TrevTrav Excel Programming 1 March 22nd 05 07:57 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"