Thread: Update Botton
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
saman110 via OfficeKB.com saman110 via OfficeKB.com is offline
external usenet poster
 
Posts: 80
Default Update Botton

Thank you. It works great.

challa prabhu wrote:
Hi,

Do the following:

1. On the View menu, point to Toolbars, and then click Control Toolbox.
The Control Toolbox toolbar is displayed.
2. Click the Command button icon on the Control Toolbox toolbar.
3. Draw a box on the worksheet. The box has CommandButton lable on the button.
4. Right-clik the Command button and click View Code. The Microsoft Excel
opens a Microsoft Visual Basic Design mode window. Write a procedure for this
command button.
5. On the File menu, click Close and return to Microsoft Excel. This will
return you back to the Excel worksheet.
6. In the Control Toolbox toolbar, click the Design mode icon to exit the
design mode. Only when you exit the design mode, you will be able to click
the command button to execute the procedure associated to this button.

Challa Prabhu

Hello All,

[quoted text clipped - 4 lines]

thx.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200707/1