Excel Dialog Box- help

[Stogie03]

Ok, I am trying to export some data from one excel workbook into another excel file. I can do this fine. But I want to bring up a window from in excel to ask for some certain information. I noticed i was able to insert a MS excel 5.0 Dialog into the workbook. I also know how to call this dialog box by using a marco.

My problem: I want a bunch of Checkboxes and labels on the form (dialog box) to have their caption/text be what is in a certain cell on a worksheet (or from a variable that gets its value from a cell). I can do this in regular VB.Net just fine. how do i set the caption/text of a checkbox, lets call it CheckBox1 to a certain cell or variable. I know this should be simple but i think i am missing something here....

[Hack]

Perhaps you could create your own custom dialog by using an Excel Userform.

[Stogie03]

Do you know away to do it in excel using VBA?

[Hack]

Are you familiar with UserForms?

You can put all the checkboxs and labels that you want on that, and write the VBA code behind it to do what you need.