UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Basic Userform Guidance Needed    
 
   
mutant1212
post May 6 2012, 11:26 AM
Post #1

UtterAccess Member
Posts: 48
From: Westby, WI



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.
Go to the top of the page
 
+
fkegley
post May 7 2012, 09:30 AM
Post #2

UtterAccess VIP
Posts: 23,583
From: Mississippi



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.
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 19th May 2013 - 05:47 PM