Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create a control in a XLS sheet
Message
 
 
To
20/02/2002 06:25:17
General information
Forum:
Visual FoxPro
Category:
ActiveX controls in VFP
Miscellaneous
Thread ID:
00622431
Message ID:
00622889
Views:
13
Sandra,

One easy way to figure out this kind of stuff is to record a macro in VB script and see what it does. Goto Tools/Macro/Record to get started. Drop the button, stop recording the macro. Then Tools/Macro/Macros.../Edit

This is what's recorded for me:

ActiveSheet.Buttons.Add(54.75, 5.25, 72, 72).Select

>I have inserted values to a XLS file in a specific cell but I need to insert a commandbutton or a checkbox etc This is what I have
>Kind Regards!!!!
>Sandra
>
>loExcel = CREATEOBJECT("Excel.application")
>WITH loExcel
> .Application.Workbooks.Open("file_name.xls")
> .application.Worksheets(1).Activate
> .Range("b2").Value = 14444
> .Range("b3").Value = ???? && here is where I need to insert the
> && button
> .visible=.t.
>endwith
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform