Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
May I use a form in an add-in
I have an add-in that fetches data from a recordset in a given place in a sheet, and does this fine
I'd also like to have in the same add-in the database connection form, where the user enters the database name, user name & password. If I do import that form in the add-in, how may I call it and refer to fields in it, as long as I can't see any way to declare a form public |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
May I use a form in an add-in
Bede,
An add-in is just a workbook saved as an add-in. As such, it can have sheets and forms which can be used as with any other workbook. You would start in a macro with in the add-in with Userform1.Show as is normal. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "BEDE" wrote in message ... I have an add-in that fetches data from a recordset in a given place in a sheet, and does this fine. I'd also like to have in the same add-in the database connection form, where the user enters the database name, user name & password. If I do import that form in the add-in, how may I call it and refer to fields in it, as long as I can't see any way to declare a form public? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
May I use a form in an add-in
Thanx
I just found the way around it. The add-in definitely has no sheets, only some subs & functions in it are used from another VBA project. So, in order to show the form in the add-in I made a public sub in the add-in project, and, to refer the fields in the form, I made some getXXX public functions and some setXXX public subs |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula (off form) that completes form data based on a result | Excel Worksheet Functions | |||
excel form. Need data extracted to spreadsheet each time a form co | Excel Discussion (Misc queries) | |||
Using a template form, advance a form number everytime you open | Excel Discussion (Misc queries) | |||
Can a form made in Excel 2002 be converted into a fillable form? | Excel Discussion (Misc queries) | |||
how can I make a form number change everytime the form is opened | Excel Worksheet Functions |