Macro Error, annoying plz help?

  • Thread starter Thread starter Drake
  • Start date Start date
D

Drake

Hi, new to this board and kinda new to Excel as well.

I created an excell file which includes various (difficult)
calculations. And it's all finished and ready for distribution :P Cept
for 2 minor things which i can't seem 2 fix. The most important one is
this Macro Error which keeps popping up when you open the file. (I
included a combo-box form, i think it's gotta do with that). Because if
u pick something from that list (combo box) the error pops up again,
very annoying of course. There is one way to prevent this as far as i
could see and that was by setting macro security low. (But this means
every user will have 2 set his security low to prevent this error).

Second thingy got to do with conditional formatting, all works well
cept if there are rather large formulas in the specific cells,
conditional formatting doesn't work :/

Thnx in advance!!


Drake
 
Show us the code.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
OK i already solved first problem (thnx 2 another board) But second on
(conditional formatting issue) still remains. Let me try to point ou
that specific problem bit more.

In one sheet i use conditional formatting so that every value in a cel
that equals "0" has to turn up in red. Each of those cells contai
various formulas and it appears that if the formula is a bit 'long
this conditional formatting doesn't take place...

For instance: It does happen with just an "IF" formula, but it doesn'
happen with an "IF" within "IF" etc formula...

Hope you understand what my problem is :rolleyes:

And that some-1 can help me ;)



Thnx in advance


Drak
 
I've just created a double-IF condition that resolves to 0 and it formats
as per CF quite happily.

What formula do you have that doesn't work?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top