Dropdowns in timesheets

[swaink]

:D Hi Everyone

I'm looking at that common issue time sheets.

At present the user has a spread sheet that spans many many rows listing all the possible activities next to which they put the time spent on that activity.

What I'd like to achieve is this:-

I want the user highlight either a single cell or several cells then select an activity from a single dropdown field that will be in the top of the form.

The activity selected shall then be displayed in the highlighted cell/s.

The days of the week are headers Mon - Sun.

The Rows shall be hourly intervals starting from say 08:30.

Does this sound achievable and if so does anyone have any suggestions on how I go about it.

Best regards

Kevin

 

[Andrew Poulsom]

You can use Data Validation for that.

1. Make a list of the items you want in your dropdown and name it eg MyList.

2. Select all the cells where you want the dropdown and choose Data, Validation from the menu.

3. In the Allow box choose List. In the Source box type =MyList. Then press OK.

 

[swaink]

Hi Andrew thanks for your reply.

I've done as you suggest and its works fine if I select a single cell and then chose from the list.

However when I select more than one cell it only enters the selected activity in the first cell.

Kev

 

[Andrew Poulsom]

You could use a ComboBox. Right click on any ToolBar and click Control ToolBox. Click the ComboBox icon and click and drag to place it on your worksheet. Right click the ComboBox and choose Properties. Set the ListFillRange property to MyList and close the Properties window. Right click again and choose View Code. Paste this code into the window on the right:

Private Sub ComboBox1_Change()
    Selection.Value = ComboBox1.Value
End Sub

Press Alt+F11 to return to your worksheet. Click the Design icon in the Toolbox (top left) to exit design mode.

 

[swaink]

Hi Andrew

Thats done the trick works a treat

Many thanks for your help

Best regards

Kev
:D :D :D

 

[mikeprice53]

Does this work differently in Office XP !

As this doesnt work for me and i get error 424 object required !