private subs

Dear, I need to run automatically three events upon opening the workbook; it seems that when I put them together within the same sub, only one runs and by-passes the others. The first sub I need to run is to enter a user name, it should be enforced, otherwise to close the workbook. At the...

Having trouble googling this querry as the Variable name Single is very common. Basically I have code that looks to see if the value in the cell is non zero, and if it is non zero then I add my variable (obtained elsewhere) to the existing .vale from the cell. But somehow the adding isn't...

I have the following code to check if the formatting of the data being entered into the text field: Private Sub txtTime1_AfterUpdate() With txtTime1 If IsDate(.Value) Then .Value = Format(.Value, "HH:MM AM/PM") Else MsgBox "Input time as HH:MM" .Value = ""...

Hi All, Thanks for checking out my question. I've been asked to create a button that only appears based on 3 of 4 values available from a dropdown box(K6). The values are "REMOVE", "ADD ON" and "REPLACE EXISTING". Here's what I have so far. I can get it to work for one value like, "REMOVE", but...