Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jpizzle
 
Posts: n/a
Default Creating button as cell


This may be a silly easy question, but im new to Excel so Id appreciate
someone's help. I was wondering if its possible to create a button
such that the button is a cell itself. So that when you click the
cell, it executes the macro assigned to the button. Also, the button
would need to keep the size and coordinates of the cell to which it is
created into. If Im not being clear please let ,me know. Thanks


--
jpizzle
------------------------------------------------------------------------
jpizzle's Profile: http://www.excelforum.com/member.php...o&userid=23920
View this thread: http://www.excelforum.com/showthread...hreadid=375550

  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

You can put a button from the Forms toolbar over that cell. If you rightclick
on the button and choose format control|properties tab, you can specify that it
move and size with cell.

And if you position the edges of the button while holding the alt-key, the
button will "snap-to" the edge of the cell.

(Rightclick on the button and then assign macro will assign the macro to the
button.)

jpizzle wrote:

This may be a silly easy question, but im new to Excel so Id appreciate
someone's help. I was wondering if its possible to create a button
such that the button is a cell itself. So that when you click the
cell, it executes the macro assigned to the button. Also, the button
would need to keep the size and coordinates of the cell to which it is
created into. If Im not being clear please let ,me know. Thanks

--
jpizzle
------------------------------------------------------------------------
jpizzle's Profile: http://www.excelforum.com/member.php...o&userid=23920
View this thread: http://www.excelforum.com/showthread...hreadid=375550


--

Dave Peterson
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
Editing cell using right mouse button Diane Miller New Users to Excel 1 May 20th 05 12:36 PM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
adding a command button to an excel cell? betelguese Excel Discussion (Misc queries) 1 March 22nd 05 03:09 AM
Clear cell contents with a button KFC / A&W Boy Excel Worksheet Functions 1 March 7th 05 09:39 AM
Dropdown with a "jump to" cell name. Like a Go button.. thom hoyle Excel Worksheet Functions 2 January 27th 05 07:55 PM


All times are GMT +1. The time now is 08:59 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"