Combo box selection will not calculate
 

I am using 3 combo boxes to select the year, month and day for a scheduling
worksheet. Each combo box is linked to a cell which is 'named' accordingly.
When I select the year and day, the calculations in the worksheet work. But
when I select the month, the calculations will not work.
If I enter the month number into the linked cell using the keyboard and
press 'enter', the worksheet calculates perfectly. Only when the month
number is entered into the linked cell by selecting in with the combo box, it
does not work.
SOMEBODY PLEASE HELP!

Combo box selection will not calculate
 

Yes. They are copies of each other, with only the list range and links changed.

Tell me more about the code you mentioned

Thanks for the prompt response.

"Patrick Molloy" wrote:

SOMEBODY PLEASE HELP! not likely to spur any faster or better response.

Have you double checked that the three comboboxes are formatted the same
way?
you could create code and assign to all three buttons that simply forces the
sheet or the range to calculate

"Perrysbox2" wrote in message
...
I am using 3 combo boxes to select the year, month and day for a
scheduling
worksheet. Each combo box is linked to a cell which is 'named'
accordingly.
When I select the year and day, the calculations in the worksheet work.
But
when I select the month, the calculations will not work.
If I enter the month number into the linked cell using the keyboard and
press 'enter', the worksheet calculates perfectly. Only when the month
number is entered into the linked cell by selecting in with the combo box,
it
does not work.
SOMEBODY PLEASE HELP!

Combo box selection will not calculate
 

Thanks for your prompt rasponse Patrick.
Yes; they are exact copies of each other, with only the list ranges and
linked cells changed.
Tell me more about that code you mentioned.

"Patrick Molloy" wrote:

SOMEBODY PLEASE HELP! not likely to spur any faster or better response.

Have you double checked that the three comboboxes are formatted the same
way?
you could create code and assign to all three buttons that simply forces the
sheet or the range to calculate

"Perrysbox2" wrote in message
...
I am using 3 combo boxes to select the year, month and day for a
scheduling
worksheet. Each combo box is linked to a cell which is 'named'
accordingly.
When I select the year and day, the calculations in the worksheet work.
But
when I select the month, the calculations will not work.
If I enter the month number into the linked cell using the keyboard and
press 'enter', the worksheet calculates perfectly. Only when the month
number is entered into the linked cell by selecting in with the combo box,
it
does not work.
SOMEBODY PLEASE HELP!

Combo box selection will not calculate
 

BTW: If I use a 'spinner' or a 'list box' it works fine. It only seems to be
the 'combo box' that is giving me trouble, and that is what would suit the
project best.

"Patrick Molloy" wrote:

SOMEBODY PLEASE HELP! not likely to spur any faster or better response.

Have you double checked that the three comboboxes are formatted the same
way?
you could create code and assign to all three buttons that simply forces the
sheet or the range to calculate

"Perrysbox2" wrote in message
...
I am using 3 combo boxes to select the year, month and day for a
scheduling
worksheet. Each combo box is linked to a cell which is 'named'
accordingly.
When I select the year and day, the calculations in the worksheet work.
But
when I select the month, the calculations will not work.
If I enter the month number into the linked cell using the keyboard and
press 'enter', the worksheet calculates perfectly. Only when the month
number is entered into the linked cell by selecting in with the combo box,
it
does not work.
SOMEBODY PLEASE HELP!

Combo box selection will not calculate
 

have some simple code,

Sub Recalculate()
Range("D3").Calculate
Sheet1.Calculate
End Sub

and have all comboboxes run it on by click events
in the sheet, in my example, D3 would have the formula that depends on the
cells uodated by the cbs



"Perrysbox2" wrote in message
...
Thanks for your prompt rasponse Patrick.
Yes; they are exact copies of each other, with only the list ranges and
linked cells changed.
Tell me more about that code you mentioned.

"Patrick Molloy" wrote:

SOMEBODY PLEASE HELP! not likely to spur any faster or better
response.

Have you double checked that the three comboboxes are formatted the same
way?
you could create code and assign to all three buttons that simply forces
the
sheet or the range to calculate

"Perrysbox2" wrote in message
...
I am using 3 combo boxes to select the year, month and day for a
scheduling
worksheet. Each combo box is linked to a cell which is 'named'
accordingly.
When I select the year and day, the calculations in the worksheet work.
But
when I select the month, the calculations will not work.
If I enter the month number into the linked cell using the keyboard and
press 'enter', the worksheet calculates perfectly. Only when the month
number is entered into the linked cell by selecting in with the combo
box,
it
does not work.
SOMEBODY PLEASE HELP!

Combo box selection will not calculate
 

No luck. 'C4' is the linked-to cell that is 'named' as 'month', and is the
cell that will work if I enter the month number with the keyboard.
I am not very knowledeable about VB code, so bear with me. This is what I
entered:

Private Sub ComboBox1_Click()
Sub Recalculate()
Range(C4).Calculate
Sheet1.Calculate
End Sub

Any suggestions?
I appreciate your help.

"Patrick Molloy" wrote:

have some simple code,

Sub Recalculate()
Range("D3").Calculate
Sheet1.Calculate
End Sub

and have all comboboxes run it on by click events
in the sheet, in my example, D3 would have the formula that depends on the
cells uodated by the cbs



"Perrysbox2" wrote in message
...
Thanks for your prompt rasponse Patrick.
Yes; they are exact copies of each other, with only the list ranges and
linked cells changed.
Tell me more about that code you mentioned.

"Patrick Molloy" wrote:

SOMEBODY PLEASE HELP! not likely to spur any faster or better
response.

Have you double checked that the three comboboxes are formatted the same
way?
you could create code and assign to all three buttons that simply forces
the
sheet or the range to calculate

"Perrysbox2" wrote in message
...
I am using 3 combo boxes to select the year, month and day for a
scheduling
worksheet. Each combo box is linked to a cell which is 'named'
accordingly.
When I select the year and day, the calculations in the worksheet work.
But
when I select the month, the calculations will not work.
If I enter the month number into the linked cell using the keyboard and
press 'enter', the worksheet calculates perfectly. Only when the month
number is entered into the linked cell by selecting in with the combo
box,
it
does not work.
SOMEBODY PLEASE HELP!