Excel - UserForm Input

[nicko101]

Hi
My problem is this
On my sheet, i have a check box. when you check the checkbox, a userform pops up asking for some data. The user types the requested data into the textbox on the userform, then clicks the button. the data then appears in a specified cell.

It works fine until the part where the data appears in the cell. How do i link th checkbox to the cell i want the data to appear in so the data appears in the right cell? (I have several checkboxes for several different cells, otherwise it would be easy) I tried using the LinkedCell property which didnt seem to work, and inttegers, but i couldnt access the integers in module1 from the userform1 code and Vice Versa. Im probably making a mountian out of a molehill with this, but hey!! Any help/simplifications would be greatly appreciated.

Thanks
nick

[Ecniv]

How do you get the checkbox to open the form?
Can you pass the form a global variable or two with the last cell used?
Or perhaps pass the form via a global variable the actual checkbox?
If you get the checkbox, are there properties of the checkbox of cell location??

[nicko101]

I didnt think it was that hard.

 Sub CheckBox1_Click()
If Sheet1.CheckBoxes(1).Value = Checked Then
    UserForm1.Show
End If

I got to CheckBox1_Click by doing 'assign macro' and clicking 'New'.

I'm not a very experienced programmer. Global Variable?

Probably Obvious

[nicko101]

Thanks, i got it now. Thanks for your help

Nick