passing control from control to the worksheet

**warehouseman** · 09-03-2008, 11:40 AM

I have a command button

Please Login or Register  to view this content.

stopone is a drop down menu that looks up information for a table on a another sheet.

Based on the stopone value now being nul another cell (A11) on the sheet should go blank but it retains the previous value from stopone. As soon as I click on the worksheet itself A11 goes blank. I've tried adding the line "Worksheets("Calculator").calculate to the code but it does nothing. It only recalculates when I click on the worksheet. What am I doing wrong and how do I do it correctly?

**royUK** · 09-03-2008, 12:00 PM

I don't know exactly what you want, maybe

Please Login or Register  to view this content.

**warehouseman** · 09-03-2008, 01:18 PM

Thank you for the reply. What I'm trying to say is that

Please Login or Register  to view this content.

doesn't work. nothing happens when it comes to that line in the routine.

**royUK** · 09-04-2008, 04:16 AM

It should calculate a sheet called Calculator, nothing will show unless you have changed that worksheet.

**warehouseman** · 09-04-2008, 07:43 AM

Thank you - we may not quite be on the same page. The sheet named "Calculator" has a drop down combobox and from that box the user can select a name from a table. The name is then replicated in a cell, for example A11. Beside the combobox is a reset command button. When the user clicks on this button it resets the value of the combobox to nul and sets the reset button visible=false. Since the value of the combobox is now nul then cell A11 should be blank and not retain the previous value. Cell A11 only goes blank if I click someplace on the worksheet. I have tried to use the command line - Worksheets("Calculator").calculate - to force the sheet to recalculate and hopefully A11 would go blank. Another curious quirk is that the name of the sheet is "Calculator" with the "C" being capitalized. However, when I type it in the command line with a lowercase "c" it automatically should become capitalized - but it does not. Any final thoughts on this problem?

**warehouseman** · 09-04-2008, 08:23 AM

Ok I have found the solution - thank you all for your help - FIRST the focus has to be taken off the command button and put on the worksheet by using the line command " Range("A11").select THEN you can use " ActiveCell.Calculate " and it recalulates the entire sheet.