Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Names of Drop_down Boxes
Hi guys, By clicking a Macro button 1, a user launches a macro One element of the macro is copying a drop down box from sheet A to sheet B. By click Marcro Button 2, the macro that is launched needs to select that copied drop down box on sheet B and delete it. Drop down box is always visible on sheet A. The problem is whenever you copy and paste a drop down box it RENAMES the drop down box with the next consecutive number, and then I cant write a macro to SELECT it to delete it, cause I dont know what the number will be. Solns...? perhaps VB to name the checkbox once it is pasted the first time...? Thanks D *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation boxes, outputting a final number from the boxes | Excel Discussion (Misc queries) | |||
Moving. Want to number boxes and inventory contents of boxes | Charts and Charting in Excel | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
Questions on combo boxes and list boxes. | New Users to Excel | |||
How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) |