cancel
Showing results for 
Search instead for 
Did you mean: 

Macro function to check cell status

mario_scheibe
Explorer
0 Kudos

Hi,

I need to check within a macro, if a cell/row is ready for data input. So far I only found the function to set the status like cell_input() / row_input(), but no function to check the current status.

Any ideas?

Best Regrds,

Mario

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member187488
Active Contributor
0 Kudos

Hi,

It's the same function you can use.
When you use "cell_input() = 1/0", you set this property. When you use if "cell_input() = 0/1", you get this property.

BR,
Ada

mario_scheibe
Explorer
0 Kudos

Hi Ada,

this is unfortunattely not working since this function has only export parameters. Means you cant only set the staus but not read.

Have already tried to us it, in an IF statment, but it do not return any values.

BR,

Mario