Visual Basic Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsProgramming Languages - MoreVisual Basic Programming

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
  #1  
Old July 29th, 2003, 01:14 PM
savioar savioar is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jul 2003
Posts: 1 savioar User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Unhappy combo box, linked

i really need help in decision here. Now i have a large excel worsheet which contains something like a database of products. So now what i need to do is to create a user friently interface. Ok, in this interface, the user will have a combobox with the list of products and each product may have more than one sizes. For each of this sizes there will be information like price and expiry date,etc...

so my plan is to create a combobox for the product and then another combobox for the sizes that links to the products combobox. So i really dont know how to do this using excel macro userform or in the worksheet itself. I dont want to use access as im not that good at it compared to using excel. Ok so when i press the search button for the products i want the other combobox containing the sizes to display the list of sizes and when i click the Display button after chossing the size, i want the information to be displayed in the following text boxes.

so the main problem here is to add the list to the combo box from another worksheet and to link the combobox.

hope anyone can help....very much appreciated

Reply With Quote
  #2  
Old July 31st, 2003, 07:08 AM
shafan's Avatar
shafan shafan is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jul 2002
Posts: 123 shafan User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 51 m 51 sec
Reputation Power: 6
once the product is selected in the Products combo clear the sizes combo (cboSizes.Clear),
loop through the Range of sizes of the selected Product in the XL sheet and load each size into the combo using cboSizes.AddItem method.
When a size is selected in the sizes combo find the right data row and display the data in the text boxes.

Another option would be to load the sizes into a list control (as apposed to a combo box) and display the data when the user selects a size from that list.

Reply With Quote
Reply

Viewing: Dev Shed ForumsProgramming Languages - MoreVisual Basic Programming > combo box, linked


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway