excel vba ask for input if calculation updates code example

Example: input box type vba

'0	A formula
'1	A number
'2	Text (a string)
'4	A logical value (True or False)
'8	A cell reference, as a Range object
'16	An error value, such as #N/A
'64	An array of values