Programming

Programming questions? Ask a programmer for answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Combo Box problem-Combo box 1 needs to use code where other…

Customer Question
Combo Box problem-Combo box 1...
Combo Box problem-Combo box 1 needs to use code where other combo boxes are populated by a Lookup. The selection in combobox1 must determine the valid selections in the remaining combo boxes.

I uploaded the file at:
http://wikisend.com/download/608526/Dave Test 06-07-10.xls

The issue is on frmCustInfo. On worksheet SSC Order Form-Page1 click the company logo and the form pop’s up. It should work that as combo box Species1 changes (i.e., Alder to Melamine) the remaining combo boxes

DoorStylePrimCode, DoorStylePrimBead, DoorStylePrimEdge, DoorStylePrimPanel

get repopulated ONLY with available choices that match that species from the Door Matrix and Drawer Matrix worksheets. Thus, if picking Species1, either initially or by changing it, the correct door style, edge profile, framing bead, and panel raise need to be the only available choices.

Currently when you change Species1, the other combo boxes do not repopulate correctly or show the correct range of choices.
Submitted: 8 years ago.Category: Programming
Show More
Show Less
Ask Your Own Programming Question
Answered in 3 hours by:
6/11/2010
Programmer: Arty, Computer Software Engineer replied 8 years ago
Arty
Arty, Computer Software Engineer
Category: Programming
Satisfied Customers: 575
Experience: 15+ years of programming, C, C++, Java, PHP, awk, ruby, shell, ASM, Forth, Raptor, M.A.R.I.E, Excel
Verified
Hi,

Thank you for using our services.

I've downloaded your xls. There is a lot of code.
May be I can fix it in 3-4 hours.

As far as I remember, problem with combo box is that their content is static and you can't change it. It is populated upon creation and can't be changed.
I see two possible scenarios - one is to create that depending combo boxes dymanically after the user selects 'Species1' or try to use another (dymanic) rows source.

Please wait for further updates.


Regards,
Arty
Ask Your Own Programming Question
Programmer: Arty, Computer Software Engineer replied 8 years ago
> Thus, if picking Species1, either initially or by changing it, the correct door style, edge profile, framing bead, and panel raise need to be the only available choices.


How can I determine which (Code, Bread,Profile,Raise) fits specific Species1?
Please refer me to specific worksheets, pages/columns.

Regards,
Arty
Ask Your Own Programming Question
Customer reply replied 8 years ago
Arty,

Sorry I went offline last night and just saw your post. The Door Matrix and Drawer Matrix worksheets are where you find the correct Door Code, Bead, Profile and Raise. If you look in column A (Code) as an example, if you scroll right, you will begin to see each of the available choices for that door code.

I hope this helps.
Programmer: Arty, Computer Software Engineer replied 8 years ago

Thank you for reply.

 

I need further clarification.

 

Suppose user selects 'Foil'. Where to take all the other data. Can you step-by-step provide what to do next on the 'Door Matrix' sheet and 'Drawer Matrix'.

 

> If you look in column A (Code) as an example, if you scroll right, you will begin to see each of the available choices for that door code.

 

There is no 'Foil' code in column A. Which data to take and in what order?

 

Regards,

Arty

 

Ask Your Own Programming Question
Customer reply replied 8 years ago
Arty

I am out of office until tonight.

Can I give you this info either later today or tomorrow?
Programmer: Arty, Computer Software Engineer replied 8 years ago

Yes, I'll see your reply on weekend.

But please provide as much details as possible, because I'm unfamilar with your table structures and program logic :-)

 

So I'm waiting for more info, not necessary now. My local time is 2:12AM

 

Regards,

Arty

Ask Your Own Programming Question
Customer reply replied 8 years ago
Arty,

Column A in the Door Matrix and Drawer Matrix worksheets is the code (or DoorStylePrimCode) field. The reason you don't see "foil" is that foil is a type or species. As an example, you will see the code Belleair which is a foil door name. If you scroll to the right, the only available species is foil.

Therefore, in the frmCustInfo, if you pick foil as the species in combo box Species1, I am trying to have the remaining combo boxes for DoorStylePrimCode, DoorStylePrimEdge, DoorStylePrimBead, and DoorStylePrimPanel to populate ONLY with the available foil doors (i.a., Abacoa, Belleair, Captiva,...) and associated Edge, Bead and Panel Raise.

Additionally, if you already have selected all the combo box info and now want to change it because say a customer wants to know the price of Cherry instead, then what I want is for the DoorStylePrimCode, DoorStylePrimEdge, DoorStylePrimBead, and DoorStylePrimPanelcombo boxes to repopulate with only the available choices for cherry.

I hope this make sense.

If you think it better to maybe use a site such as gotomeeting or dimdim where we can talk through this, please let me know.

Thanks in advance for your help.
Programmer: Arty, Computer Software Engineer replied 8 years ago

Sorry for delay.

 

I'm resuming this thread, it should be no longer closed.

 

So, if I select 'Foil' in 'Species1' combo box, I should get the following PrimCodes (from Drawer Matrix, by searching selected Species in 'AS' column):

 

Abaco Shaker, Bahama Shaker, Bal Harbor, Bimini, Biscayne, Captiva, Daytona, Doral, Gulfstream, Hollywood, Key Largo, Las Olas, Marathon Shaker, Martinique, Montego, Naples Shaker, Nassau, Palm Beach, Pompano, ...

 

 

Next, how to popuate associated DoorStylePrimEdge, DoorStylePrimBead and DoorStylePrimPanel ? Suppose customer selects 'Key Largo'. Where to search next and what value to get to populate Edge, Bead and Panel?

 

Regards,

Arty

 

Ask Your Own Programming Question
Customer reply replied 8 years ago
Arty,

Thanks for the reply.

When you select foil, the DoorStylePrimCode comes from the Door Matrix worksheet. The DrwrStylePrimCode comes from the Drawer Matrix worksheet.

Regarding Edge, Bead and Panel, in those same matrix worksheets, if you scroll left or right you will see column headings such as:

Edge 1, Edge 2....
Bead 1, Bead 2...
Panel 1, Panel 2...

As with the different "door codes", i.e., Abaco Shaker, Belleair, etc., the only available choices should be what is available for that particluar species/type. Currently, I did not enter any Edge, Bead or Panel yet for foil doors. If you want to make 1 up as say Edge Test 1, Bead Test 1, and Panel Test 1 and insert those into the appropriate cells on the Door Matrix and Drawer Matrix worksheets then you would be able to test the code. As an example, maybe use Edge Test 1 in the cell for Abaco, Edge Test 2 in the cell for Belleair, etc.

I hope this helps.

Thanks.
Customer reply replied 8 years ago
Arty,

The thread still is closed.

Are you working on this?
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a programmerLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask Arty Your Own Question
Arty
Arty
Arty, Computer Software Engineer
Category: Programming
Satisfied Customers: 575
575 Satisfied Customers
Experience: 15+ years of programming, C, C++, Java, PHP, awk, ruby, shell, ASM, Forth, Raptor, M.A.R.I.E, Excel

Arty is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

ATLPROG

ATLPROG

Computer Software Engineer

7,677 satisfied customers

MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

LogicPro

LogicPro

Computer Software Engineer

7,175 satisfied customers

Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.

unvadim

unvadim

Computer Software Engineer

1,168 satisfied customers

Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.

lifesaver

lifesaver

Computer Software Engineer

950 satisfied customers

Several years of intensive programming and application development experience in various platforms.

ehabtutor

ehabtutor

Computer Software Engineer

936 satisfied customers

Bachelor of computer science, 5+ years experience in software development, software company owner

TheDoctor

TheDoctor

Software Engineer

893 satisfied customers

M.S. in Internet Information Systems

The-PC-Guy

The-PC-Guy

Software Engineer

848 satisfied customers

Extensive Knowledge in PHP, MYSQL, CSS & Javascript

< Previous | Next >

Related Programming Questions
I have a simple user form populating a table. Data is
I have a simple user form populating a table. Data is entered using combo boxes populated from a named rage on another sheet and then the adjacent cell is populated using vlookup. This all works fine … read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Gents is there anybody that could look and see if they can
Gents is there anybody that could look and see if they can help please. I have created a Pricing workbook for construction works. However, I am having problems completing. The Plan is, in each sheet n… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Hi! I will like to know if you can help me with a program.
Hi! I will like to know if you can help me with a program. I need this program today can you help me. I was searching and I know several people ask you the same program. Please let me know if you can … read more
LogicPro
LogicPro
Computer Software Engineer
Bachelor of Technology
7,175 satisfied customers
Step 1 Requirements Airline Reservation System Bluebird
Step 1: Requirements – Airline Reservation System Bluebird Airlines needs a program to assign boarding passes on its only plane which has a seating capacity of 20. They want to use an alphanumeric sea… read more
LogicPro
LogicPro
Computer Software Engineer
Bachelor of Technology
7,175 satisfied customers
Bluebird Airlines needs a program to assign boarding passes
Bluebird Airlines needs a program to assign boarding passes on its only plane which has a seating capacity of 20. They want to use an alphanumeric seat number, and they want to be able to assign a pas… read more
ehabtutor
ehabtutor
Computer Software Engineer
Bachelor's Degree
936 satisfied customers
how to update an excel cell once only when it equals a formula I have been using this
how to update an excel cell once only when it equals a formula I have been using this but when B1 equals a formula it doesn't work hope you can help Private Sub Worksheet_Change(ByVal Target As Range)… read more
J. Mar
J. Mar
IT Specialist
Master's Degree
341 satisfied customers
Hi there. I have another program. Problems 1. I have a worksheet with a list upon colums B
Hi there. I have another program. Problems 1. I have a worksheet with a list upon colums B is not blank on first instance enter date in colum A and label cell with "F4-"&Numeric number that increments… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Bluebird Airlines needs a program to assign boarding passes
Bluebird Airlines needs a program to assign boarding passes on its only plane which has a seating capacity of 20. They want to use an alphnumeric seat number, and they want to be able to assign a pass… read more
ehabtutor
ehabtutor
Computer Software Engineer
Bachelor's Degree
936 satisfied customers
For Logic Pro I need this in C++ and need it to run in
For Logic Pro: I need this in C++ and need it to run in Visual Studio without errors. Thanks! Bluebird Airlines needs a program to assign boarding passes on its only plane which has a seating capacity… read more
LogicPro
LogicPro
Computer Software Engineer
Bachelor of Technology
7,175 satisfied customers
Bluebird Airlines needs a program to assign boarding passes
Bluebird Airlines needs a program to assign boarding passes on its only plane which has a seating capacity of 20. They want to use an alphanumeric seat number, and they want to be able to assign a pas… read more
LogicPro
LogicPro
Computer Software Engineer
Bachelor of Technology
7,175 satisfied customers
For John D John, I am in the process of creating purchase
For John D John, I am in the process of creating purchase order systems in excel that will allow me to manage my purchases over a 31 day calendar month and consolidate and give me an update on my purc… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
p just increased value to $65 as now i really need this asap.
just increased value to $65 as now i really need this asap. Tip will be provided if its supplied fast. if you are working on this plz post working so i know someone is helping me. here's what i need: … read more
Nilesh
Nilesh
Bachelor\u0027s Degree
649 satisfied customers
Hi, I need a C++ program that will follow the guidelines
Hi, I need a C++ program that will follow the guidelines stated below: Bluebird Airlines needs a program to assign boarding passes on its only plane which has a seating capacity of 20. They want to us… read more
Nilesh
Nilesh
Bachelor\u0027s Degree
649 satisfied customers
i need help on the DLL part. if you can tell me how to send
i need help on the DLL part. if you can tell me how to send you zip folders by either email or some web site i will send what i got to you so far cause im almost finish For this project, create a .DLL… read more
ehabtutor
ehabtutor
Computer Software Engineer
Bachelor's Degree
936 satisfied customers
I am new to access 2007. I have a last name field data type
I am new to access 2007. I have a last name field data type is text on my form. The user needs the option of choosing 1 of 3 choices. 1. change last name (if they choose this then they can type in the… read more
Ruben G.
Ruben G.
Vocational, Technical or Trade Scho
69 satisfied customers
I am trying to write & run a vba macro. It is failing. This
I am trying to write & run a vba macro. It is failing. This is a subsection of the code: Dim VOS As Long Cells(LastREGISTERRow, 5).Select 'ActiveCell.FormulaR1C1 = _ "=IF(ISERROR(VLOOKUP(RC[-2], 'SYST… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I am working with an education template and i need to be able
I am working with an education template and i need to be able to gather information for each student and make a list of all the classes that they attend. I would like the ability to have each one of t… read more
Mike D - Computer/Electronics
Mike D - Computer/Electronics
IT Manager
High School or GED
117 satisfied customers
I am using microsoft Excel 2007 Problem 1 I have 12 worksheets
I am using microsoft Excel 2007: Problem 1: I have 12 worksheets (different months) of data. I have a summary sheet where I use vlookup functions to pull data from one of the monthly sheets. I would l… read more
Danny B
Danny B
Associate Degree
62 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x