Multiconditional if statement problem

[Steffen Thomsen]

Hi

What im trying to achieve:

I have a multiple checkboxes linked to different cells and need to do somethin dependent on the linked cells value (True, False or vbNullstring)

Please Login or Register  to view this content.

*Edit: The part that isn't working is the If statement

It work ok when i only have this code

Please Login or Register  to view this content.

But then i loose the append functiomality when there is allready data in curCell.Offset(-1,-1)

Hope for some good help

Steffen Thomsen

[Steffen Thomsen]

Hi,

Anyone got any help on this, or am i unclear in any way?

Steffen Thomsen.

[mohd9876]

im guessing that the problem is in this line

Please Login or Register  to view this content.

may be the value in the cell is a number and you are comparing it to a string..

if that's not the case please tell me what you are trying to achieve or upload a workbook and i will be glad to help you out

[Steffen Thomsen]

Hi,

Thanks for the reply.

It is actually a string that is compared, ill try to describe it a bit better.

I have a calendar, each sheet is a month, at each date there is a checkbox, so the user can choose wich dates to insert appointments or hourregistration.

When a checkbox is chosen and the values to be insertes are choosed from the comboboxes, the code has to check if the date thats going to be inserted on has a value in it or not, if theres is something in the cell it has to append the values choosen, if it is blank it has to insert the values choosen.

I can get it to work when it's blank but not when it has to append.

It will take some tim for me to draft up a dummy, but if it's the only way, i will do it.

Steffen Thomsen