Macro Code for Selection Detection

[Tobin1]

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?

Tobin Sparks

http://www.nov.com

 

[Tobin1]

Never Mind, I figured it out.
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

http://www.nov.com

 

[TheTick]

This would be a good opportunity to experiment with the various events associated with textbox: Change, KeyPress/Up/Down, Before/AfterUpdate, Enter, etc.

Honesty may be the best policy, but insanity is a better defense.

http://www.EsoxRepublic.com

-SolidWorks API VB programming help

 

[Tobin1]

TheTick

Thanks for your responce. That sounds like a good idea. I'll check it out.

Thanks

Tobin Sparks

http://www.nov.com