if with Macro

[john150]

hello,

i have a problem with my excel sheet. I want to when i click to button, excel will check value of A1 and when A1=1 will make process 1, when A1=2 will make process 2, ....

Can you help me please?


Thanks

 

[JoeMo]

hello,

i have a problem with my excel sheet. I want to when i click to button, excel will check value of A1 and when A1=1 will make process 1, when A1=2 will make process 2, ....

Can you help me please?


Thanks

Welcome to the board.

Are you looking for something like this?

Sub MyProcess()
Select Case Range("A1").Value
Case 1: 'Code to do process1
Case 2: 'Code to do process2
'More of this
End Select

 

[john150]

Hello,
thanks for your respond very much!

On click of button check:

When value of A1=1
process this

When value of A1=2
process this

.
.
.

Thanks!

 

[JoeMo]

Hello,
thanks for your respond very much!

On click of button check:

When value of A1=1
process this

When value of A1=2
process this

.
.
.

Thanks!

Care to share your thoughts on what "process this" means?

 

[john150]

if A1=1 take value from B1 and put it to C1 and edit value in A1 to 2
if A1=2 take value from B1 and put it to C1 and edit value in A1 to 3, and .........

Its ok?

 

[JoeMo]

if A1=1 take value from B1 and put it to C1 and edit value in A1 to 2
if A1=2 take value from B1 and put it to C1 and edit value in A1 to 3, and .........

Its ok?

Two problems. (1) if the value in B1 remains the same, then the value in C1 is the same for all values in A1, so why bother to look at A1 at all? (2) Doing what you have asked for looks like an endless loop.

 

[john150]

no endle loop....i think that when one of condition is true, the macro will stop

 

[john150]

or know macro choose item from list?

http://ctrlv.cz/cFxW

When macro will make process, macro will select item from list. This list will set number in A1.

 

[JoeMo]

no endle loop....i think that when one of condition is true, the macro will stop

By condition you mean the value in A1? If yes, how many conditions are there? If a condition is met and the macro then changes the value in A1 to another condition, doesn't that trigger the macro again and so on ...............?

 

[john150]

10x condition.

If you want, i will, send file with. http://tmp.pavelfrcek.cz/kalk.xlsx

Here is my calculator.