Search:

dear users,

for my work i'm working on a project that we can track the expire dates on different products.
to make it easy for my colegues, i made a userform that they can fill in. i only run...

Im using excel 2010. and in collum G i want the msg to apear when you put yes 1 and for no another

i'm not using a code yet and in this collum a have a validation with Yes or no

Hello again,

I have another question for my work, i want to make a list for the orders we get from customers.
i have a sheet with all the facts i need but i want one thing in it.

when i put in...

i sleightly become crazy..... if i press no i get a error and it sais method add of object customproject properties has failed how to resolve it :S

no i want a shortcut so i can activate the pop up again so when i press {insert} the pop up is activate

the error has gone a little mistake i wrote .none instead of .clear

and for my shortcut where do i place the line:

On Error Resume Next...

I want a shortcut to make it pop up again.
And the value is date but when i erase it i get a error

it works :) but now i have more wishes :blush:

1. is their a way to make the popup come back when it is hidden
2. the last code Worksheets("ivulinstructies").Range("A1").Value = Date gives a date...

Yes when i press yes nothing happens (msgbox close) but when i press no i'm receiving same error

so this vba code is only posibble when i open a sheet

my bad the sheet is not called ivulinstructies but invulinstructie but right now the error that its not supported

Problems with this code when i press yes i get error code 9 the subscript is out of range. it is in this line

Worksheets("ivulinstructies").Range("A1").Value = Date'

when i press no i get error...

Can somebody write a clear tutorial because im a newbie

Hi guys,

I'm totally new in automation of excel.

im busy with a project for my sister. when she starts excel a msgbox will pop up with this code

Private Sub Workbook_Open()
MsgBox "my...