ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA for prompt to fill in the certain cell (https://www.excelbanter.com/excel-programming/391135-vba-prompt-fill-certain-cell.html)

Frank Situmorang

VBA for prompt to fill in the certain cell
 
hello:

In lotus we can create a macro to ask us in the middle of the process to
copy to which range. The macro in lotus is like {?} then we sreach the cursor
downward the cell B for example, and then we can copy it to that range.

I want to make in excel similar to it, I want if we hit control D, iin cell
d5 , it will automatically Type "Finished dated 12 Jun 2007"" for today. To
morrow I will put in cell d20 the same word with the tomorrow 's date.

Can anybody teach me how to do it?, The wording of the VBA could be
"Finished" & To day()? or NOW()

Thanks in advance

Frank

Gary''s Student

VBA for prompt to fill in the certain cell
 
Assign the shortcut CNTRL-d to the following macro:

Sub frank()
Dim s As String
s = "Finished dated "
ActiveCell.Value = s & Format(Now(), "dd mmm yyyy")
End Sub


--
Gary''s Student - gsnu200728


"Frank Situmorang" wrote:

hello:

In lotus we can create a macro to ask us in the middle of the process to
copy to which range. The macro in lotus is like {?} then we sreach the cursor
downward the cell B for example, and then we can copy it to that range.

I want to make in excel similar to it, I want if we hit control D, iin cell
d5 , it will automatically Type "Finished dated 12 Jun 2007"" for today. To
morrow I will put in cell d20 the same word with the tomorrow 's date.

Can anybody teach me how to do it?, The wording of the VBA could be
"Finished" & To day()? or NOW()

Thanks in advance

Frank


NickHK

VBA for prompt to fill in the certain cell
 
Frank,
Why is D5 today, but D20 for tomorrow ?
What about Wednesday ?

Range(??).value="Finished dated " & format (date, "dd mmm yyyy")

NickHK

"Frank Situmorang" wrote in message
...
hello:

In lotus we can create a macro to ask us in the middle of the process to
copy to which range. The macro in lotus is like {?} then we sreach the

cursor
downward the cell B for example, and then we can copy it to that range.

I want to make in excel similar to it, I want if we hit control D, iin

cell
d5 , it will automatically Type "Finished dated 12 Jun 2007"" for today.

To
morrow I will put in cell d20 the same word with the tomorrow 's date.

Can anybody teach me how to do it?, The wording of the VBA could be
"Finished" & To day()? or NOW()

Thanks in advance

Frank




Frank Situmorang

VBA for prompt to fill in the certain cell
 
Nick:

Wahtr I want to do that my clerck will just hit the macro, and it will type
those letters in D5. just for example that the copied range bottom left is in
E5, and tomorrow she will copy started from A6 to E20, so she will hit the
botton and it will type tommorows date. I just want to know it as a memo
which one to be updated later. Because the copepied range will be transfer to
another file.

I think Gary will give a light on this.

I would appreciate if you still have any idea

Frank

"NickHK" wrote:

Frank,
Why is D5 today, but D20 for tomorrow ?
What about Wednesday ?

Range(??).value="Finished dated " & format (date, "dd mmm yyyy")

NickHK

"Frank Situmorang" wrote in message
...
hello:

In lotus we can create a macro to ask us in the middle of the process to
copy to which range. The macro in lotus is like {?} then we sreach the

cursor
downward the cell B for example, and then we can copy it to that range.

I want to make in excel similar to it, I want if we hit control D, iin

cell
d5 , it will automatically Type "Finished dated 12 Jun 2007"" for today.

To
morrow I will put in cell d20 the same word with the tomorrow 's date.

Can anybody teach me how to do it?, The wording of the VBA could be
"Finished" & To day()? or NOW()

Thanks in advance

Frank





Frank Situmorang

VBA for prompt to fill in the certain cell
 
Thanks Gary for your smart idea. since this will be used for many excel
files, because each project will have a seperate file, Can we save the macro
in an excel file but can be run in any other project excel files when we open
it?

Thanks for your advice

Frank


"Gary''s Student" wrote:

Assign the shortcut CNTRL-d to the following macro:

Sub frank()
Dim s As String
s = "Finished dated "
ActiveCell.Value = s & Format(Now(), "dd mmm yyyy")
End Sub


--
Gary''s Student - gsnu200728


"Frank Situmorang" wrote:

hello:

In lotus we can create a macro to ask us in the middle of the process to
copy to which range. The macro in lotus is like {?} then we sreach the cursor
downward the cell B for example, and then we can copy it to that range.

I want to make in excel similar to it, I want if we hit control D, iin cell
d5 , it will automatically Type "Finished dated 12 Jun 2007"" for today. To
morrow I will put in cell d20 the same word with the tomorrow 's date.

Can anybody teach me how to do it?, The wording of the VBA could be
"Finished" & To day()? or NOW()

Thanks in advance

Frank


CoRrRan

VBA for prompt to fill in the certain cell
 
Frank Situmorang wrote:
Thanks Gary for your smart idea. since this will be used for many excel
files, because each project will have a seperate file, Can we save the macro
in an excel file but can be run in any other project excel files when we open
it?

Thanks for your advice

Frank


"Gary''s Student" wrote:

Assign the shortcut CNTRL-d to the following macro:

Sub frank()
Dim s As String
s = "Finished dated "
ActiveCell.Value = s & Format(Now(), "dd mmm yyyy")
End Sub


--
Gary''s Student - gsnu200728


"Frank Situmorang" wrote:

hello:

In lotus we can create a macro to ask us in the middle of the process to
copy to which range. The macro in lotus is like {?} then we sreach the cursor
downward the cell B for example, and then we can copy it to that range.

I want to make in excel similar to it, I want if we hit control D, iin cell
d5 , it will automatically Type "Finished dated 12 Jun 2007"" for today. To
morrow I will put in cell d20 the same word with the tomorrow 's date.

Can anybody teach me how to do it?, The wording of the VBA could be
"Finished" & To day()? or NOW()

Thanks in advance

Frank

You can do this by using an AddIn. Just create a clean Excel Workbook
and add the VBA code to it. Then save the workbook as an Excel AddIn and
publish this to the users who are going to use it. Let them install the
AddIn (Tools -- AddIns...) and everytime Excel starts, the AddIn will
be loaded and the user-defined functions and macro-procedures within it
are available for use.

HTH, CoRrRan

Frank Situmorang

VBA for prompt to fill in the certain cell
 
Thank you CoRrRan. I will try it.

Frank

"CoRrRan" wrote:

Frank Situmorang wrote:
Thanks Gary for your smart idea. since this will be used for many excel
files, because each project will have a seperate file, Can we save the macro
in an excel file but can be run in any other project excel files when we open
it?

Thanks for your advice

Frank


"Gary''s Student" wrote:

Assign the shortcut CNTRL-d to the following macro:

Sub frank()
Dim s As String
s = "Finished dated "
ActiveCell.Value = s & Format(Now(), "dd mmm yyyy")
End Sub


--
Gary''s Student - gsnu200728


"Frank Situmorang" wrote:

hello:

In lotus we can create a macro to ask us in the middle of the process to
copy to which range. The macro in lotus is like {?} then we sreach the cursor
downward the cell B for example, and then we can copy it to that range.

I want to make in excel similar to it, I want if we hit control D, iin cell
d5 , it will automatically Type "Finished dated 12 Jun 2007"" for today. To
morrow I will put in cell d20 the same word with the tomorrow 's date.

Can anybody teach me how to do it?, The wording of the VBA could be
"Finished" & To day()? or NOW()

Thanks in advance

Frank

You can do this by using an AddIn. Just create a clean Excel Workbook
and add the VBA code to it. Then save the workbook as an Excel AddIn and
publish this to the users who are going to use it. Let them install the
AddIn (Tools -- AddIns...) and everytime Excel starts, the AddIn will
be loaded and the user-defined functions and macro-procedures within it
are available for use.

HTH, CoRrRan


Frank Situmorang

VBA for prompt to fill in the certain cell
 
CoRrRan:

I need more clarifications on this:

1. when you said Add, is it thru view webcode on the clean sheet and we put
the VBA on it?
2. when you said published to user. is it to ask users to install when
users open an excel file, is OK?, or anytime user other files he/she has to
install it.

Thanks in Advance,

Frank



"CoRrRan" wrote:

Frank Situmorang wrote:
Thanks Gary for your smart idea. since this will be used for many excel
files, because each project will have a seperate file, Can we save the macro
in an excel file but can be run in any other project excel files when we open
it?

Thanks for your advice

Frank


"Gary''s Student" wrote:

Assign the shortcut CNTRL-d to the following macro:

Sub frank()
Dim s As String
s = "Finished dated "
ActiveCell.Value = s & Format(Now(), "dd mmm yyyy")
End Sub


--
Gary''s Student - gsnu200728


"Frank Situmorang" wrote:

hello:

In lotus we can create a macro to ask us in the middle of the process to
copy to which range. The macro in lotus is like {?} then we sreach the cursor
downward the cell B for example, and then we can copy it to that range.

I want to make in excel similar to it, I want if we hit control D, iin cell
d5 , it will automatically Type "Finished dated 12 Jun 2007"" for today. To
morrow I will put in cell d20 the same word with the tomorrow 's date.

Can anybody teach me how to do it?, The wording of the VBA could be
"Finished" & To day()? or NOW()

Thanks in advance

Frank

You can do this by using an AddIn. Just create a clean Excel Workbook
and add the VBA code to it. Then save the workbook as an Excel AddIn and
publish this to the users who are going to use it. Let them install the
AddIn (Tools -- AddIns...) and everytime Excel starts, the AddIn will
be loaded and the user-defined functions and macro-procedures within it
are available for use.

HTH, CoRrRan



All times are GMT +1. The time now is 09:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com