How to control buttons within a frame

Pisolippia · May 15th, 2002, 04:36 AM

Hi all,
have added a frame to my worksheet and, using its own toolbox have added a Listbox and a Button into it.
What I need to accomplish is to add some code for the button to copy the content (if not blank) of the listbox into another cell of the worksheet.
The problem I have is that I cannot find a way to add any code for the button but only for the frame.
Please help.
Cheers, Stefano.

Ivan F Moala · May 15th, 2002, 10:58 AM

Quote:

On 2002-05-15 03:36, Pisolippia wrote:
Hi all,
have added a frame to my worksheet and, using its own toolbox have added a Listbox and a Button into it.
What I need to accomplish is to add some code for the button to copy the content (if not blank) of the listbox into another cell of the worksheet.
The problem I have is that I cannot find a way to add any code for the button but only for the frame.
Please help.
Cheers, Stefano.

Hi Stefano
Unfortunately you can't do this. The Frame
control is NOT an ActiveX control.
Suggest you try this using an ActiveX control
say the Image control available from the
Cotrol Toolbox and Not the Forms.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 15th, 2002, 04:36 AM	#1
Pisolippia New Member Join Date: Mar 2002 Location: ITALY Posts: 16	Hi all, have added a frame to my worksheet and, using its own toolbox have added a Listbox and a Button into it. What I need to accomplish is to add some code for the button to copy the content (if not blank) of the listbox into another cell of the worksheet. The problem I have is that I cannot find a way to add any code for the button but only for the frame. Please help. Cheers, Stefano.