VBA get valuef from a text box

[JeniaL]

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.

 

[JeniaL]

found how to do that. god bless Google and macro recorder
code attached
still have one question. while macro is in tun how can i fill description in two lines?

 

[ferdo]

Hi
Check this.

Regards
Fernando

https://picasaweb.google.com/102257836106335725208

- Romania

https://picasaweb.google.com/103462806772634246699/

- EU

 

[JeniaL]

thanks a lot ferdo.

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

 

[ferdo]

I believe your catvba is empty.

Regards
Fernando

https://picasaweb.google.com/102257836106335725208

- Romania

https://picasaweb.google.com/103462806772634246699/

- EU

 

[JeniaL]

attached new project. having problems with a message when i don't fill one of part properties. i want macro to get me an opportunity
to get back to form and fill missing properties. now if i leave part number blank macro fails.

 

[lardman363]

I cannot open your vba file, it says you have too many line continuations. Can you use some condition like:

If sPartNumber <> "" then 'If the part number is not blank
'continue with code