AlwaysError
New Member
- Joined
- Mar 6, 2009
- Messages
- 3
Hi Gentlemen/Ladies
I got a userform (Registration) containing 3 textboxes. I'd like to enter information in textbox3, run cmd button, the textbox value will automaticly be placed in the the cells i have selected as target.
Sheet1
Column F (F14:F58) contain employee names, row 13 Datevalues from 01.01.2009 to 31.03.2009.
The target should be a result of inputvalues in the userform (Registration). Date from/to [textbox1] - [textbox2] and selected employee names in column F (column E got the detachment information for each employee, maby use this as filteroption in the userform also?)
Ex.
Textbox1 = 01.01.2009, Textbox2 = 06.01.2009, Textbox3 = "Test"
Employee names in (F14:F17 & F28:F31). When execute cmd button the value "Test" should be plased in the cells of interest.
hmm.. Not so easy to explain, but I hope someone might be able to help me
I got a userform (Registration) containing 3 textboxes. I'd like to enter information in textbox3, run cmd button, the textbox value will automaticly be placed in the the cells i have selected as target.
Sheet1
Column F (F14:F58) contain employee names, row 13 Datevalues from 01.01.2009 to 31.03.2009.
The target should be a result of inputvalues in the userform (Registration). Date from/to [textbox1] - [textbox2] and selected employee names in column F (column E got the detachment information for each employee, maby use this as filteroption in the userform also?)
Ex.
Textbox1 = 01.01.2009, Textbox2 = 06.01.2009, Textbox3 = "Test"
Employee names in (F14:F17 & F28:F31). When execute cmd button the value "Test" should be plased in the cells of interest.
hmm.. Not so easy to explain, but I hope someone might be able to help me