Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically Creating a Command Button
To All,
I have a spreadsheet we are using a work and need a little help with the code. In one column (A)we have a six digit number that automatically creates a bar code in the next column(B). What I would like to have is when the bar code is created in column(B) a command button is automatically created in column (C). I know how a command button is created, but need it to automatically be created in column (C). If anyone can help me would with the code that would be great. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically Creating a Command Button
Worksheets(1).OLEObjects.Add "Forms.CommandButton.1", _
Left:=10, Top:=10, Height:=20, Width:=100 i have yet to figure out how to put it in cell c sorry " wrote: To All, I have a spreadsheet we are using a work and need a little help with the code. In one column (A)we have a six digit number that automatically creates a bar code in the next column(B). What I would like to have is when the bar code is created in column(B) a command button is automatically created in column (C). I know how a command button is created, but need it to automatically be created in column (C). If anyone can help me would with the code that would be great. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code for my Command Button to automatically copy and insert a new | Excel Discussion (Misc queries) | |||
Creating a Command Button on a worksheet | Excel Discussion (Misc queries) | |||
VB's Command Button vs Form's Command Button | Excel Programming | |||
Creating Name for a Command Button | Excel Programming | |||
Creating Command button Conditionally | Excel Programming |