Macro Code for Selection Detection
Macro Code for Selection Detection
(OP)
Howdy All,
I've attached a Macro that I need some help with.
This is just a "see if I can do it this way" kind of Macro.
The form has three TextBoxes and I want to detect if the user has put any text in them, then, only use the TextBoxes that have text in them to create one SW Note.
I have commented the Macro to further explain the problem.
Can anybody help or show me some other simple way to do this?
I've attached a Macro that I need some help with.
This is just a "see if I can do it this way" kind of Macro.
The form has three TextBoxes and I want to detect if the user has put any text in them, then, only use the TextBoxes that have text in them to create one SW Note.
I have commented the Macro to further explain the problem.
Can anybody help or show me some other simple way to do this?
Tobin Sparks
www.nov.com






RE: Macro Code for Selection Detection
It occurred to me just as I was falling asleep.
For anybody interested I just changed the following:
If Len(TextBox1.Text) > 0 Then Settings(0) = 1 Else Settings(0) = 0
If Len(TextBox2.Text) > 0 Then Settings(1) = 1 Else Settings(1) = 0
If Len(TextBox3.Text) > 0 Then Settings(2) = 1 Else Settings(2) = 0
Tobin Sparks
www.nov.com
RE: Macro Code for Selection Detection
http://www.EsoxRepublic.com-SolidWorks API VB programming help
RE: Macro Code for Selection Detection
Thanks for your responce. That sounds like a good idea. I'll check it out.
Thanks
Tobin Sparks
www.nov.com