Selecting particular records

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
 
M

Mark

Hi,

If no one else responds, send me a sample sheet or your
workbook up to 1mb, and I will write something for you.
Please provide as much info as possible. But what you may
need are scroll bars that, when moved, shows a set range
(1 to 50 records) into a listbox.

Or left and right Scroll arrows with a textbox between
them showing what record number is showing. One click on
right arrow brings up first fifty records into a list box.
This might be better.

Regards
Mark

Please allow 2 to 3 days for a result.

Visit my sites:
http://au.geocities.com/excelmarksway
http://www.geocities.com/excelmarksway
 
Top