how to convert inch to mm and mm to inch using checkbox

[noelcjf]

how do i change mm to inch and inch to mm just by using check box to convert using vba macro.

[FDibbins]

And where is this check supposed to be?

[noelcjf]

And where is this check supposed to be?

The checkbox is at b11 and D11

the convert cells are D13, E13, F13, G13, H13 ,J13, K13, L13, M13 AND N13 in rows.

[sintek]

This will give you an idea...assign this macro to check box 98

Please Login or Register  to view this content.

For 97 replace * sign with / and change 98 to 97

[noelcjf]

This will give you an idea...assign this macro to check box 98

Please Login or Register  to view this content.

For 97 replace * sign with / and change 98 to 97

thank you, but if i want to convert back to MM which area do i need to change?

[sintek]

Just as I said...

For 97 replace * sign with / and change 98 to 97
Assign this macro to check box 97

Please Login or Register  to view this content.

[noelcjf]

Just as I said...

For 97 replace * sign with / and change 98 to 97
Assign this macro to check box 97

Please Login or Register  to view this content.

Thank you, it solved my problems.

[sintek]

Glad I could assist...Tx for rep +