Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
betelguese
 
Posts: n/a
Default adding a command button to an excel cell?

I've added a macro that runs vba code to perform some calculations. I wish
the user to click on a button in a cell on the worksheet to run this macro. I
am having trouble adding a command button to a cell? I have the control
toolbox up, but when i try to click on the command button or drag it to the
cell, nothing happens.
What to do?
  #2   Report Post  
Gary Brown
 
Posts: n/a
Default

Left click on the command button on the control toolbox. Release the mouse
button. Move the mouse cursor to the cell you want to put the command
button. Left click and the command button should appear. Right click to
get to the popup menu that allows you to view code.
HTH,
Gary Brown



"betelguese" wrote in message
...
I've added a macro that runs vba code to perform some calculations. I wish
the user to click on a button in a cell on the worksheet to run this
macro. I
am having trouble adding a command button to a cell? I have the control
toolbox up, but when i try to click on the command button or drag it to
the
cell, nothing happens.
What to do?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding a prefix to a cell by using a formula Audrey in OHIO Excel Discussion (Misc queries) 4 February 24th 05 04:49 PM
Adding contents of cells by clicking in Excel 2002 Kevin Gordon Excel Discussion (Misc queries) 7 January 11th 05 04:49 PM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 04:55 PM
Writing many lines on a same Excel 2000 cell freeposte Excel Discussion (Misc queries) 2 December 8th 04 02:45 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 08:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"