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....