A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

adding a command button to an excel cell?



 
 
Thread Tools Display Modes
  #1  
Old March 22nd 05, 02:09 AM
betelguese
external usenet poster
 
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?
Ads
  #2  
Old March 22nd 05, 03:09 AM
Gary Brown
external usenet poster
 
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?



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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:40 AM.


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