Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Onboard Excel help...teach a man to fish...
Question for Excel 2000 9.0.8950 SP-3
I'd like to use the onboard VB help within Excel, but I get the horizontal, two-headed arrow when trying to use the Index search. Answer Wizard doesn't work either, 'Contents' does work, but that is needle in a haystack type searching. Native Excel help seems to work find, just not the VB component. 1) Any way to get the Index search to work? 2) Is there a searchable 'Index' on this site other than the discussion threads? Thanks for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Onboard Excel help...teach a man to fish...
When I press F1 from within the Excel VBA compiler the Help window
comes up showing the reserved word I had highlighted or a prompt to enter a topic. Is that what you see? We all know Help can be as frustrating as it is informative... as for searching the net, how do you access this newsgroup? When I go here http://groups.google.com/group/micro...UTF-8&oe=UTF-8 ....searching is pretty straightforward. What are you searching for? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Onboard Excel help...teach a man to fish...
When I'm in a code window within the VBA editor and hit F1, I get the
standard dialog with 3 tabs, Contents, Answer Wizard, and Index. The Answer Wizard and Index won't allow anything to be keyed (doubled headed arrow). No problem on the Answer Wizard, it's useless anyway, but a big problem not being able to use the Index. At the moment I'm trying to write some code to read a text file, parse the text, append it to an existing series of cells, then update some ranges in an associated chart. As a specific example, there is a Property or Function named CELLS(... that I cannot find help for at all. Can find it for CELL(..., but not CELLS(... I need to find the last populated row, so I can add the data from that point downward. Not looking for the answer (only feeding me a fish), need to figure out how to make MS 'HELP' work (teach a man to fish). Have the same problem with Access, didn't have it with Access 97, which actually worked. Thanks. "Dave O" wrote: When I press F1 from within the Excel VBA compiler the Help window comes up showing the reserved word I had highlighted or a prompt to enter a topic. Is that what you see? We all know Help can be as frustrating as it is informative... as for searching the net, how do you access this newsgroup? When I go here http://groups.google.com/group/micro...UTF-8&oe=UTF-8 ....searching is pretty straightforward. What are you searching for? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Onboard Excel help...teach a man to fish...
I'm with you, and I agree. And in the interest of productivity, here
are some reserved words you might use: OPEN "path filename" FOR OUTPUT AS #[integer] LINE INPUT #[integer], [variable] Parse [variable] using MID, LEFT, RIGHT, TRIM etc functions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel docs not saving as excel docs | Excel Discussion (Misc queries) | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Display form from an VB application in Excel | Excel Discussion (Misc queries) |