Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple Autofilter
All i want to do is make it so Userform2 shows when the workbook is open.
It will prompt the user for a number (TextBox1). Excel then uses that number to autofilter Worksheet("Expense") which Goes from A2 to I559 Then is dropped into cells A2 in Worksheet("Miles") and Worksheet"(Expense Non-AMEX) Any Idea how to do this? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple Autofilter
How does the number affect your autofilter?
To get you started, you will need an Auto_Open macro to load and show UserForm2: Sub auto_open() Load UserForm2 UserForm2.Show End Sub Do the autofiltering in the UserForm2 code...Once again, I don't know what you meant by "Excel then uses that number to autofilter Worksheet("Expense") which Goes from A2 to I559." How's that? Where does the user's number come into play? As for using the textbox's value, before unloading your UserForm, run this code: Sheets("Miles").Cells(2,1).Value = TextBox1.Value Sheets("Expense Non-AMEX").Cells(2,1).Value = TextBox1.Value Hope this helps, Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
simple question on autofilter | Excel Programming |