Excel Tips - Helpful Hints On The StatusBar

A file I designed some time ago and have been using without problem doesn't work on a colleagues machine. After stepping through the code, I've discovered that when trying to execute the command
Application.Statusbar = False
Excel closes, without even displaying an error message.

I've never seen this kind of behaviour before, and I'm not sure how to deal with it, other than avoiding the use of the statusbar for reporting the progress of my code.

The machine that won't run this code has Excel 97 installed. My machine has Excel 2000.

Any assistance gratefully received!

I have a webbrowser object embedded within Sheet1 (called WB)

In my code if I type WB.
I get offered a list of valid sub-parameters (Document being one of
them)
If I choose Document then type . again, I don't see the list of valid
sub-parameters for the next level down

I am particularly interested in the sub-parameters of Document.Links and
Document.Images

I can compile my code and guess the parameter below links, e.g.
..Document.Links(0).src - but I don't know until run time whether the
'src' parameter is valid or not

I have tried looking at this page
<http://msdn.microsoft.com/workshop/a...collections/li
nks.asp>
This makes a reference to the href property, but nowhere can I find a
complete listing of the properties

Any help appreciated
--
Mike
Please post replies to newsgroup to benefit others
Replace dead spam with ntl world to reply by email

Hi all,

since I can't find what I want in existing freeware, I decided to write it myself The goals are set high, if I ever get there remains to be seen...

Aimed functionality is more or less like the statistics and review source code from MZ-Tools, but more stats and metrics, combined with a calltree builder.

Only just started and I already have a 'problem', though it's not really a problem, more of a "What would be the best way to..."-question.
Here it is: when examining code lines, what is the most failsafe way to make sure there is a comment on the end of the line and then to determine the starting ' of the comment?
Currently I'm taking into account cases like:
Code:

'this is a full line comment, easy to detect
dim test$ 'this is my string "Test ' String"
dim test$ 'this is my string "Test ' String
test$ = "Test ' String "" going on ""' " 'and this is the "comment"'

It is starting to make my head spin

I'd be grateful for any ideas on the matter...
Also, laughing with my ambitious project is allowed, though constructive ideas and suggestions are more welcome

Hello!

Through this forum's work, I have assembled the macros/VBA onto a floating toolbar that I seem to always use when I am working with a workbook.

I want to make sure that it is complete, and there isn't VBA that a) everyone else uses that b) I never use or knew about that c) could help me.

When you work with workbooks, is there VBA in your collection that you would share that you always seem to use and I have missed? (I know that there is alot of VBA out there; I am mainly concerned about the ones that can be used to error-check workbooks before they go out to many users.)

Thanks!

VR/Lost

Hello!

Through this forum's work, I have assembled the macros/VBA onto a floating toolbar that I seem to always use when I am working with a workbook.

I want to make sure that it is complete, and there isn't VBA that a) everyone else uses that b) I never use or knew about that c) could help me.

When you work with workbooks, is there VBA in your collection that you would share that you always seem to use and I have missed? (I know that there is alot of VBA out there; I am mainly concerned about the ones that can be used to error-check workbooks before they go out to many users.)

Thanks!

VR/Lost

In order to help new posters improve the quality of their posts, we would like to invite members to use a generic signature. This is completely optional, and of course you can still include other components in your signature.


The following signature is proposed:
Quote:

- Posting guidelines, forum rules and terms of use

- Try searching for your answer first, see how

- Read the FAQs

- List of BB codes

To apply this signatu
Go to the ‘Quick Links’ menu on your MrExcel forum toolbar, and click ‘Edit Signature’.
Copy the code below and paste it into the editor.
Click ‘Save signature’

Signature code:
Code:

 [SIZE=1]
   - Posting [url=http://www.mrexcel.com/forum/showthread.php?t=515787]guidelines[/url],  [url=http://www.mrexcel.com/forum/showthread.php?t=99490]forum rules[/url] and [url=http://www.mrexcel.com/terms.shtml]terms of use[/url]
    
   - Try searching for your answer first, [url=http://www.mrexcel.com/forum/showthread.php?t=174000]see how[/url]
    
   - Read the [url=http://www.mrexcel.com/forum/faq.php]FAQs[/url]
    
   - List of [url=http://www.mrexcel.com/forum/misc.php?do=bbcode]BB codes[/url]
 [/SIZE]

I am searching for inexpensive yet easy and helpful Excel tutorials that are preferably online. Specifically I need to be shown how to convert charts into graphs and the like... Any suggestions would be greatly appreciated. Thanks!

What is the easy way to create forms in different sheets.......

In Main Sheet (Sheet1) each row contains some informations about a particular item.
I want to create Forms in separate Sheets and datas for this Form 1 (Sheet2) should be datas of Row#1 of Sheet1 & datas for this Form 2 (Sheet2) should be datas of Row#2 of the Sheet1.......

Hi Guys,
Does anyone know of a web site which offers Excel tips and tricks.
Is there a free book which I can download that will give me tips and tricks.
Thanking you in advance,
Regards

J-O

There have been many times when I have had to use if statements to determine if a value is between another range of values, and I hated having to create the AND() statements over and over for this, so I finally created an IsBetween UDF that works like a charm, and oddly enough it seems to be able to determine if a single character (a, b, c, etc) is between two other characters!:

Syntax:

=ISBETWEEN([Value],[LowerBound],[UpperBound],[EqualType - (Optional)])

Where Value is the number to determine if it lies between LowerBound and UpperBound. EqualType is a boolean argument where 0, FALSE, or null will return GREATER THAN and LESS THAN (no equal to) and a Number other than 0 or TRUE will return GREATER THAN OR EQUAL TO and LESS THAN OR EQUAL TO.

Code:

Public Function IsBetween(value As Variant, lower As Variant, upper As Variant, Optional equaltype As Boolean) As Boolean
    Select Case equaltype
        Case False
            If value > lower And value < upper Then
                IsBetween = True
            Else
                IsBetween = False
            End If
        Case True
            If value >= lower And value