Couldn't wait. My method works fine...
> I don't have a bad-value test ...
I understood your example 100% & wasn't question it, sorry.
> "Call" is ... not required... parameters ... inside parentheses
I know this. I Shouldn't have mentioned it. I just don't usually include it for Msg boxes.
> I had the MsgBox inside the With because I included
> the .Text from the textbox in its parameters.
Ahhh! Some of this does make sense, Steve. I sez to self. I'll keep that trick in mind.
> > I understand the With TextBox and its components ...
> A With doesn't have components, it simply makes the
> components of the TextBox available ...
Ah well. A Rose is a Flower. I picked that term not knowing if there was better jargon figuring you'd know what I meant, but I still think it flys ok. They could be considered components of the With as well, no? ... parameters...operands... arguments, even (for argument sake...so to speak)(;-)
Here's my functioning snippet - cool to see text now selected. (I also played with some of the things to help understand the function of each - especially the Cancel.Value)
. If Mem_FirstMM < 1 Then
. MsgBox "The First memory can not be < 1 ..." ' detail omitted
. With Mem_FirstMM
. .SelStart = 0 ' Cusor at left
. .SelLength = Len(.Text) ' Nice touch. Select it all
. End With
. Cancel.Value = True ' kill User goof.
. End If
Thanks, Steve N.
... Still playing ...
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (10) |
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar