Asterix
02-27-2008, 07:37 AM
Sorry, this one must be easy and therefore a repost but I'm struggling to find anywhere that explains it in simpleton terms.
1) I'm using the following text to load and display a user defined form ("body_text_form") in the hope that the text displayed in the udf's text box will be that already assigned to the calling macro variable "body_text"
Load body_text_form
MsgBox body_text_form.TextboxText = body_text
body_text_form.Show
Obviously that doesn't work, though I don't know why. I can't use an input box (easily) as the body_text value can go over multiple lines. How should the code read please?
2) [I could start a new thread but it's related]...assuming the user is happy with what's originally displayed OR what they've amended it to, they'd then press an "OK" button that I've tagged on to the bottom of the udf...2nd question is, how do I assign a "close form and continue macro" action to that button.
1) I'm using the following text to load and display a user defined form ("body_text_form") in the hope that the text displayed in the udf's text box will be that already assigned to the calling macro variable "body_text"
Load body_text_form
MsgBox body_text_form.TextboxText = body_text
body_text_form.Show
Obviously that doesn't work, though I don't know why. I can't use an input box (easily) as the body_text value can go over multiple lines. How should the code read please?
2) [I could start a new thread but it's related]...assuming the user is happy with what's originally displayed OR what they've amended it to, they'd then press an "OK" button that I've tagged on to the bottom of the udf...2nd question is, how do I assign a "close form and continue macro" action to that button.