Combo Box Help

  • Thread starter Thread starter Pedros
  • Start date Start date
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 :
 
does the lack of response mean:
1. that this cannot be done?
2. That I have not been clear enough?
3. That I am going about this in the wrong way?
 
Hello Pedros,

It would be helpful to see the worksheet and any code you have written
so far. If you want you can e-mail your workbook to me at
(e-mail address removed). I'll be happy to look it over.

Sincerely,
Leith Ross
 
Back
Top