Macro to change UserForm Label does not work?

Hi Guys,

I am using the following code within a loop to alternate between Image3 and Image4. No Problem, but if I add a label to Alternate in Color, Still only the Images do their thing, but nothing happens to the Label?

Please Login or Register  to view this content.

etc.

What am I doing wrong?

Hello Winon,

Do you have a sample workbook I can look at?

Nothing wrong. Make sure thae label name is correct

Hello Leith,

It took me a while, to chop down the 8Mb file down something almost decent. The sample really looks weird.

But the issue at hand remains the same.

Thank you for helping out!

Sorry Leith, I cannot get the Upload File Manager to respond! There are about 30 previously uploaded files which have not been cleared, and that may be the problem!

Hello Winon,

The IT people have been backing up the server, defragmenting it, etc. All this work is supposed to make the attachments database retrieval faster. Unfortunately, no one knows how long it will be before normal forum operation is restored. In the meantime, you could upload the file to a public file sharing site like MediaFire and post that link.

Forecolor changes the font colour of the label. I suspect you want BackColor?

My Friend!

Hello OnErrorGoto0,

Indeed, it is the ForeColor I want to Change, not the BackColor.

Thank You,

Are you keeping well?

Apart from 15-20 "do you want to leave this page" messages a day here, yes, thank you. You?

@ Leith,

My first and long time Friend on the Forum,

What excuse is this? You yourself is probably just as well qualified, if not better, to quickly solve the little I.T. issues!

@ OnErrorGoto0,

Don't even mention it, I constantly receive a messge - "Are you sure you want to navigate away from this Page?" and then a little threat warning me that if I do - " You will lose all information" or "Data" Or something to that effect. Bla..., Bla...

But in all fairness, I do appreciate the new look. Somehow got used to it, and I must admit that they seem to be working hard at still making it even better. Growing pains I suppose. But what an Ideal opportunity to pull the "Mickey" out of them all the same!

Otherwise, I am keeping well, thank you. Spent the entire day for 19 hours non stop learning, or trying to learn how really to get to grips with VBA. Problem is the Syntax. I am convinced it must be written on a sacred scroll somewhere, and only accessible to a prevelidged few. And only a few of these people are prepared to part with some of that knowledge in tiny bits of custom adapted code, specific to a particular problem. EEEKK!!!

VBA is not that difficult really - at least to get the basic syntax. Personally I find it useful to have reference books on pure VBA (rather than related to a specific application's object model) as well as application-specific tomes.
Many other languages are, to me at least, far harder.

O'Reilly have a VB/VBA in a nutshell reference. There is also the VBA programmers handbook that was recommended to me - worth buying if you can find it for the code samples alone.