VBA get valuef from a text box
VBA get valuef from a text box
(OP)
hi all.
cant find how to get a text from the text box in vba. i need to start up macro then fill out some part properties and assign that to parameters. buy how to get a value? it's not a constant value.

i have a macro that adds additional properties but i want to speed up this by skipping pressing alt+enteranks. i'd like to fill it with a form.
thanks in advance.
cant find how to get a text from the text box in vba. i need to start up macro then fill out some part properties and assign that to parameters. buy how to get a value? it's not a constant value.

i have a macro that adds additional properties but i want to speed up this by skipping pressing alt+enteranks. i'd like to fill it with a form.
thanks in advance.





RE: VBA get valuef from a text box
code attached
still have one question. while macro is in tun how can i fill description in two lines?
RE: VBA get valuef from a text box
Check this.
Regards
Fernando
https://picasaweb.google.com/102257836106335725208 - Romania
https://picasaweb.google.com/103462806772634246699... - EU
RE: VBA get valuef from a text box
having some issues with a script. when i leave part number field or no matter what field empty, message pops up and then macro goes to the end.
in this case i want macro to give me an opportunity to fill empty field before proceeding to the end.
any help will be appreciated
project attached
RE: VBA get valuef from a text box
Regards
Fernando
https://picasaweb.google.com/102257836106335725208 - Romania
https://picasaweb.google.com/103462806772634246699... - EU
RE: VBA get valuef from a text box
to get back to form and fill missing properties. now if i leave part number blank macro fails.
RE: VBA get valuef from a text box
CODE -->