IF Cell value is given error then show warning msg as user form

[ootkhopdi]

hi all

i have create a worksheet in which cell "c4" value is filled by input box value..
i want to create warning user form which show on error i.e.

cell c4 is blank or cell value of C4 given error in calculation or cell value of i2, which is the result of value on cell c4 value is = #N/A
or cell i2 value is blank..

please give me solution..
i tried many codes but not solve problem..

please give me solution..

 

[ajamess]

Something like...

c4value = workbooks("Workbookname").Worksheets("Worksheetname").range("c4").value
i2value  = workbooks("Workbookname").Worksheets("Worksheetname").range("I2").value

if iserror(c4value) then
    msgbox "Cell C4 contains an error."
Elseif iserror(i2value) then
    msgbox "Cell I2 contains an error."
Elseif c4value = "" then
    msgbox "Cell C4 is blank."
Elseif i2value = "" then
    msgbox "Cell I2 is blank."

Endif

 

[ootkhopdi]

Thanks ajamess. This code gave me a way to solution.. thanks

 

[ootkhopdi]

Can some one tell me how can go direct to row of other sheet which cantains value = text box1 value in column c.
means textbox1 value is working as hyperlink address