Textboxes within Userform to display info based on combobox selection

[alter54]

Hi everyone,

I have posted similar threads with no luck. Please help me solve this problem.

Attached is a sample of what I am working with. I have a userform that I want to display certain information from within the spreadsheet based on the combobox selection. Then, I want to be able to type new data into those same text boxes where the info is displayed and have that change the cells within the spreadsheet from where the data was originally pulled.

First, how do I get the userform to display data based on the combox selection?

Second, (if it is possible) how can I make that data changeable from within the same userform?

I am just learning VB and have been stuck on this problem for almost a week! Please help!

Thanks!

[cplmckenzie]

You were on the correct track.

I just made a few minor modifications.

Try this and see if this is the functionality you want.

cplmckenzie

[alter54]

cplmckenzie,

That worked perfectly! Thank you so much, this is a huge help!

[cplmckenzie]

Since this has resolved your issue.

Please mark this thread as resolved.

cplmckenzie

[alter54]

cplmckenzie,

I have one more issue that I didn't see until I tried to apply all of your code to my actual document.

I will attach an updated sample worksheet - I have a "percentage of total sales" row beneath my "projected sales" row.

Is there any way to make the code skip every other row?

[alter54]

Here is the updated sample spreadsheet.

Thanks again for all of your help.

[cplmckenzie]

alter54,

Try this and see if it works.

If so, please mark thread as solved.

cplmckenzie