Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute beginner
Hi,
I'm an absolute beginner with excel. I've had a lot of experience with VB6, but code aside, it's a different beast! How do you turn a cell into a button that responds to a click event in which I can write code? Or how is a similar thing done. Events! I need Events! Thanks very much your humbly Ant |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute beginner
I'm an absolute beginner with excel. I've had a lot of experience with
VB6, but code aside, it's a different beast! How do you turn a cell into a button that responds to a click event in which I can write code? Or how is a similar thing done. Events! I need Events! You can put a CommandButton right on the spreadsheet and then work with that. If you haven't already done so, select View/Toolbars/Visual Basic from Excel's menu bar. Click on the Control Toolbox icon from the Visual Basic tool bar (looks like a wrench and hammer crossed over each other). This will add the Control Toolbar to the spreadsheet's tool bars. From the Control Box, click on the CommandButton icon and draw it onto your spreadsheet (size it as necessary). If you are not already in Design Mode, select the Design Mode icon from the Visual Basic tool bar (it's to the right of the Control Toolbox icon). Once that is done, right click the CommandButton and select Properties from the popup menu; double-click it to reach its event coding window. Rick |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute beginner
Hi Rick,
Thanks very much! That'll get me started Cheers Ant "Rick Rothstein (MVP - VB)" wrote: I'm an absolute beginner with excel. I've had a lot of experience with VB6, but code aside, it's a different beast! How do you turn a cell into a button that responds to a click event in which I can write code? Or how is a similar thing done. Events! I need Events! You can put a CommandButton right on the spreadsheet and then work with that. If you haven't already done so, select View/Toolbars/Visual Basic from Excel's menu bar. Click on the Control Toolbox icon from the Visual Basic tool bar (looks like a wrench and hammer crossed over each other). This will add the Control Toolbar to the spreadsheet's tool bars. From the Control Box, click on the CommandButton icon and draw it onto your spreadsheet (size it as necessary). If you are not already in Design Mode, select the Design Mode icon from the Visual Basic tool bar (it's to the right of the Control Toolbox icon). Once that is done, right click the CommandButton and select Properties from the popup menu; double-click it to reach its event coding window. Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Absolute cell reference will not remain absolute. | Excel Worksheet Functions | |||
Beginner to VBA | Excel Programming | |||
VB beginner | Excel Programming | |||
How can I do an Absolute Cell Reference but non Absolute Cell Pais | Excel Programming | |||
How can I do an Absolute Cell Reference but non Absolute Cell Pais | Excel Programming |