show multiple rows on a user form
 

HI,

I would like to know if it is possiblem and how ,,, to have a user enter a
value ona form, then search fior that value on a sheet (it will appear
multiple times) and show the related colums of information on the same or
another form.

I thought of using the value entered to initiate a filter and then showing
the spreadsheet, but would prefer to show the values on a form..

Thanks
Wayner
--
WayneR

show multiple rows on a user form
 

showing values on a userform is just a matter of loading them into a control
or controls. So you should not have a problem.

If your question is how to find multiple instances of a value in a column,
look in Excel VBA help at the sample code for the FindNext command.

--
Regards,
Tom Ogilvy




"WayneR" wrote:

HI,

I would like to know if it is possiblem and how ,,, to have a user enter a
value ona form, then search fior that value on a sheet (it will appear
multiple times) and show the related colums of information on the same or
another form.

I thought of using the value entered to initiate a filter and then showing
the spreadsheet, but would prefer to show the values on a form..

Thanks
Wayner
--
WayneR