Textbox - populate with month name and values based on Combobox selection

**Lukael** · 09-02-2015, 07:30 AM

Hi,

I have dates in column A, drop-down list in column B, and values in column C. I want to display month name and values for each month If I select value from combobox.

Example - value "P" (Combobox "Petrol") entered in column B:

January : 233

February : 345

March : 444 etc...

This is my code:

Please Login or Register  to view this content.

Problem is that I get only one result displayed in textbox. How can I change this to all months ?

Sample is attached !

Thanks for help !

**MickG** · 09-02-2015, 07:52 AM

Perhaps this:-

Please Login or Register  to view this content.

**Lukael** · 09-02-2015, 08:00 AM

What A stupid mistake, I should only add textbox.text

I'm too tired today for any programming

thanks mickG !

**MickG** · 09-02-2015, 08:09 AM

You're welcome

Textbox - populate with month name and values based on Combobox selection

LinkBack

Thread Tools

Rate This Thread

Display

Textbox - populate with month name and values based on Combobox selection

Re: Textbox - populate with month name and values based on Combobox selection

Re: Textbox - populate with month name and values based on Combobox selection

Re: Textbox - populate with month name and values based on Combobox selection

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How do I populate a specific range in one ComboBox based of selection of another ComboBox?

Textbox to populate based on combobox selection

Calculating/adding userform textbox values based on combobox selection and display to cell

Populate textbox based off ComboBox Selection

Populate TextBox based off ComboBox selection

[SOLVED] Excel Userform: Populate other controls (i.e. textbox & combobox) based on combobox select

[SOLVED] How do I make a selection from a combobox on my VBA userform populate a textbox?

Bookmarks

Bookmarks

Posting Permissions