inputbox value

Hi, I am trying to hide all rows where the Surgery name is not equal to the value input into the InputBox, this Inputbox is triggered after the word "WORKER" is input into A1 as this is the correct column label for my report. I have these two Subs in the same sheets code, which may be why it's...

I want activate an input box (using VBOkCancel) if there is a zero or null value in a cell. If per chance the user does not enter a number using the input box I want the the sub to select the cell and then exit the sub. My problem is that the input box is not coming up empty. It has the value...

Hello.....Frnds M trying to put ms value in Range("A1") but when i run the Macro2 instead of date it showing Default time 12:00:00 AM, I dont' knw why .? Pls help me ....Thanks IN Advance! Sub macro1() Dim ms As Date MsgBox ms Range("A1").Value = ms End Sub Sub macro2() Dim ms As Date ms =...