[ExcelVBA] Re: XL2007 Unable to select Form TextBox with code

 

> One I like is the EnterFieldBehavior property, ...

This is set already to SelectAll. Tabbing into the TextBox has the entire contents selected as I want, but not so with the Cancel.Value thingy.

> There also seem to be SelStart and SelLength properties...
I have been unable to get these to do what I Help seems to be saying.
SelStart = 0 (set cursor to beginning) and SelLength = 3 (select 3 characters) aren't doing what the help is saying, but instead, the next Form Control in the Tab order gets selected instead of the current TextBox...Arrrrg!

Something else perhaps like some condition must not be correct. Some fiddling is in order.

Thanks, Steve N.

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (5)

Recent Activity:

• New Members 2

Visit Your Group

----------------------------------
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

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___