Excel Userform

[WheresTheBeef]

How do you control where the output of the data generated from filling out the user form is generated? The tutorial only generates the data into the first available row. Can I control where each text box in particular is added? Say if I want the date to be generated at Column C Row 15 and continously generated one below that, how can I make that happen. I hope this isn't too confusing, but I'm a novice and had no luck researching my problem on the web. Thank you.

[john55]

maybe this

Please Login or Register  to view this content.

[WheresTheBeef]

Thank you for the info. Worked wonderfully.

Another question, I have a textbox that is kept disabled based on the response to a ButtonOption. I have also set that ButtonOption to be selected automatically when the userform is opened. That works fine. But when I start/open/intialize the userform, this textbox that I want disabled (even with this OptionButton that is "automatically selected") is still enabled. If I click to the other ButtonOption and back to the one that disables the textbox it works in disabling the textbox. But when opening the userform it is enabled even though this OptionButton is automatically selected...

Thank you.

[john55]

not sure if it helps you but you can try it and do some tests..

Please Login or Register  to view this content.

[WheresTheBeef]

Thanks John, I'll test it tomorrow. Pretty exhausted now, been looking for a calendar to use as a date picker on Office 2010 64bit to no avail. How can microsoft **** up something as simple as a the calendar control with their newer versions. Unforntunetely, the more I learn about code for Excel or web design the more and more ludicrous it becomes. They really could make everything soooooooooo much more simple. And it

[john55]

hope it helps you!
and for calendar, did you try to add it from toolbox (in yr UserForm) -> additional controls...? or ask for help here (open a new thread for calendar, or better, attache a test file of what you want to get)
yes, it (the excel) makes our office duties much more easier...