|
-
Jan 25th, 2005, 02:12 PM
#1
Thread Starter
New Member
Excel - UserForm Input
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|