loDrop = loSheet.Dropdowns.add(1,1,20,100) where the parameters are left,
top, width, height
Then
loDrop.additem("Test")
You also have removeitem and removeallitems
Allen
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Tristan Leask
Sent: 09 November 2006 11:10
To: [EMAIL PROTECTED]
Subject: Excel Forms (dropdowns)
Hi Guys,
I am trying to create an excel file with a dropdown list (form) from
within my VFP code. I have so far managed to do everything I want
except add the 1 form that is required for the sheet. If I add the
dropdown manually from within excel, I can reference to it from code,
but I cannot seem to create a new one.
Info...
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.13.32/523 - Release Date: 07/11/2006
13:40
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
