Refresh UserForm to display data that is linked to combobox selection

**alter54** · 08-14-2012, 03:24 PM

I've created a UserForm that will display historical data based on the month that I select from a ComboBox. Within the UserForm, there are also input boxes where, using the displayed information to help me make an accurate decision, I can enter new data that will go into another database within the workbook.

How do I make my UserForm "refresh", once I select the month, to display the correlating information from my workbook database?

I think a CommandButton might be a good addition but I don't know how to link the two objects.

(By the way, I just started learning VBA last week so I may not understand the most technical terminology.)

Thanks for the help!

**MaczaQ** · 08-14-2012, 03:39 PM

Consider to attache example workbook with dummy data for us.
For now is difficult to imagine what should be filtered. Whe have to see data structure, then we will try to help You.

**alter54** · 08-14-2012, 04:28 PM

maczaq,

Attached is a simplified example of what I am trying to do.

After selecting the month in the ComboBox, I want to press refresh and have the current projections be displayed. Then, if I feel that the projections are inaccurate based on the historical sales, I can update them in the UserForm.

So far my If Then statements haven't worked to pull projections for the selected month. I am also reading up on how to make my "Accept" command button work.

Let me know if you need more info.

Thanks.

**MaczaQ** · 08-14-2012, 05:00 PM

a part for get a value from sheet to userform without using "Refresh" button

copy below code into userform code section (any place)

Please Login or Register  to view this content.

**alter54** · 08-16-2012, 01:10 PM

I tried your code with no luck but I realized that my table is different than the sample I gave you.

Attached is a new document that more accurately reflects what I am working with.

Thanks.