Hi All,

I am reasonably new to VBA and need some help with a userform.

My problem is:

I have a spreadsheet with dates running down column A. The dates ar
each week of the financial year and begin in row 5.

basically I want a userform to perform the task of displaying
selected week only.

I have created a combo box with the date range that is in th
spreadsheet.

The function I want is that when the user selects a specific date
want this to be the only row displayed.

Example: User selects 25/09/2006 (which is in row 17) and clicks OK.
Rows 4-16 and rows 18-57 are hidden.

thanks in advance :

--
Pedro
-----------------------------------------------------------------------
Pedros's Profile: http://www.excelforum.com/member.php...fo&userid=2820
View this thread: http://www.excelforum.com/showthread.php?threadid=56414