Access UserForm through automation and create controls and event handlers

R

Rovshan

Hi,

I've developed a web app (ASP.NET). It contains an
application form that registered users fill in. now
client asked to make the same thing in excel for offline
users. that is after creating application form in admin
interface admin presses synchronize button and excel file
is generated containing questions and it must use
controls like ListBox, DropDown, CheckBox etc. I'm new to
this kind of task. I want to use a UserForm that will
open when the user opens workbook. My question is: Can I
dynamically create UserForm object using COM interfaces
and add controls and event handlers to them? I looked at
Application and Workbook object but can't find anything
suitable

Thank you,
Rovshan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top