P
Pedros
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 :
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 :