Combo Box Help
 

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

Combo Box Help
 

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?


--
Pedros
------------------------------------------------------------------------
Pedros's Profile: http://www.excelforum.com/member.php...o&userid=28202
View this thread: http://www.excelforum.com/showthread...hreadid=564148

Combo Box Help
 

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
. I'll be happy to look it over.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=564148