OK Dave & Derek,
All I needed was help to select TextBox text since the Help descriptions of the two Sel… thingys didn't `do it' for me. Dave's sample made it clear that the two are needed.
I understand the use of the With...End With just fine. Since I rarely need to change multiple properties of any single item, I have little need to use it.
It was simply an off-hand attempt at a descriptive term for what is specified within the With structure.
When I'm working on something very heavily, I use more advanced coding
On the other hand, the VBA I'm doing now is spread over long periods and I am more likely to write some pretty rag-tag code. I may just as well duplicate some code once, rather than go to the trouble of writing a general subroutine and setting things up to pass parameters. Lemme' see…? Do I want to pass by value or Ref…? Do I want a function or a subroutine…? Ah heck. I'll just have two similar subs and be done with it. Copy and Paste can be a friend also. I comment out the wazoo, so I can follow myself in a year or two…
Hopefully my nomenclature was acceptable this time… (;-)
Cheers, Steve, N.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (15) |
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