Combo Box Help

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

Pedros

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?
 
L

Leith Ross

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Weekly Report 2
Combo box 0
Date Stamp by User and cell value 8
combo box 2
Hidden sheet bleeds through 3
Userform dropdown doesn't go away 0
Combo or list box 0

Top