Selecting particular records

  • Thread starter Thread starter gundu
  • Start date Start date
G

gundu

Hi

I have an excel sheet with dialog box having default values.I wan
particular records from the sheet when I click any value in the dialo
box.Like when I click the first value it should show me the 1-5
records and for the second value it should show next 50 records in th
sheet.I would appreciate if someone helps me.

Thank
 
Perhaps you could add some code to the button that will run an
AutoFilter or Advanced Filter on the worksheet, using a start and end
value from your dialog box.

Record the steps as you apply a filter manually, and you'll have a good
start to the code.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

tangent line 2
Vlookup and multiple data 5
Excel VBA - Problem with Closing Print Preview 0
Create sorted list based on cell values 7
Write record from Form to new row in spreadsheet 1
Finding the next record in a column 2
Searching a row ( record ) 2
links to a second sheet 2

Back
Top