userform autofilter

  1. D

    Change UserForm dynamically based on input

    Hi MrExcel, I'll greatly appreciate your input re the issue below. I'm looking for an option to add elements (such as ListBoxes) to a Userform in a dynamic/interactive way: the number of ListBoxes (as well as their names, tab indices etc.) should depend on a specific input value (say, on the...
  2. K

    VBA Userform

    Hello, I have created an excel user form that displays the data entered on a spreadsheet and also does a few calculations on data as well. I entered a bunch of data, but realized there are a few more calculations I need it to do. Is there some way of writing the calculations in vba, then...
  3. B

    Excel 2003 Listbox hyperlinks

    I have a userform I am working on that basically acts as an advanced filter. I am barely versed in vba so I put my mild skills to use by editing a template. One of the functionalities that it is missing is that I can't seem to get the filtered items that show up in the listbox to be clickable...
  4. M

    Would like to display data using Userform to select line from a table

    Am trying to create a macro that will launch a user form, allow the user to select a value from column A and then have the values on that line displayed.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> My simple table looks like this. The top...
  5. M

    Autofilter in Userform2.Spreadsheet1

    Afternoon all, I'm having some trouble with the code to autofilter the results in spreadsheet1 that i've added in to a userform (userform2). I have columns A - F showing with all rows, which works fine. I have been able to enable the autofilter, as follows: With Spreadsheet1...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top