User form to post data and charts according to user defined selections

**siroco79** · 12-12-2013, 10:17 AM

Hi there,

I need to create a functionality (userform?) in Excel that would allow a number of users to define preferences, using check boxes and dropdown menus. Once made the selections they hit a button that would retrieve data and load charts (ideally on the fly - ideally according the selection or formerly created, so they can be loaded and brought up to the "results" page).

Am I dreaming? Is that possible?

This is a very early stage and little description has been posted, but just would like to know whether it is possible and if you could point me out to the right information sources or tutorials to start with it, as I have not found anything so far that could help me with this.

Many thanks!!!

**Sc0tt1e** · 12-12-2013, 10:45 AM

Open Excel
right click top ribbon and select "Control Toolbox"
From this select "Button" and create in your excel sheet

Select Alt F11 to open VBA editor
Insert userform (this will create a blank form which you can then tailor).

Personally I use a blank spreadsheet (usually Sheet 3) and create random codes and drop downs there.

Define name
Create the list you want your drop down boxes (one option per line), select the whole area and in the top left corner where you see the cell value delete the value and typwe in the name oif your options.

On your user form create a combobox and in the Properties window search for "RowSource", in there type = sheet and name of drop down (=Sheet2!Names).

Then right click the form and select "View Code", this will open the window to type in all the fancy VBA code you want.

In a module you want to create the below sub which when you select the box in excel will open your userform.

Please Login or Register  to view this content.

I hope this is enough to get you started

**siroco79** · 12-12-2013, 11:16 AM

Many thanks!

I guess that I was expecting the sort of answer: "Yes, retrieving data and loading charts is possible according to user preferences from a userform". Is there any way to achieve this without VBA?

To me it is really relevant to the user to visualize data (from the worksheet) and displaying existing charts or loading them (this sounds a too complex, right?)

THanks!