May 6 2012, 11:26 AM
I feel silly for not being able to figure this out, or find a solution on the net...
I have a spreadsheet with data in columns A-M. I am trying to find instruction on how to make command buttons that would allow me to search columns B&C for a text string. Also, I'd like a way to scroll through the data in the userform...like a scrollbar or spinbutton control. Any help would be greatly appreciated.
Data is in "sheet1" in rows 4-36912.
May 7 2012, 09:30 AM
You may be able to do this with Excel's Filter command. You'll need column headings across the tops of each column. And a way to insert new data into the rows.
On the Data tab, Excel 2007, there is a Filter button. First click anywhere inside the mass of rows and columns you want to search. Then click the Filter button. Drop down arrowheads will appear on each column heading. The users can click those to type in or pick what they want to see in columns B & C.
If you need to add and delete rows, then you will want to use the DataForm, which is available on the Customize Quick Access Toolbar selection when you right-click the ribbon.