Look to find a formul that will make an item rec
Closed
rwarren445
Blocked Profile - Jan 15, 2014 at 05:30 PM
- Posts
- 2
- Registration date
- Monday January 13, 2014
- Status
- Member
- Last seen
- January 15, 2014
Blocked Profile - Jan 15, 2014 at 05:30 PM
Related:
- Look to find a formul that will make an item rec
- Formule little alchemy - Guide
- Formule of excel - Guide
- Recover items recently removed from this folder - Guide
- Which shortcut key is used to remove the selected items? - Guide
- The item referred to by this shortcut cannot be accessed - Forum - Windows 7
3 replies
Ok, you want a change based on the sheet change?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If UCase(Target.Value) != "" Then
Target.Value = thedate;
End If
End Sub
You will need to populate the "thedate" variable with what ever info you wish to put on the sheet!
//ark
-Moderator/Contributor
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If UCase(Target.Value) != "" Then
Target.Value = thedate;
End If
End Sub
You will need to populate the "thedate" variable with what ever info you wish to put on the sheet!
//ark
-Moderator/Contributor
rwarren445
Jan 15, 2014 at 04:08 PM
- Posts
- 2
- Registration date
- Monday January 13, 2014
- Status
- Member
- Last seen
- January 15, 2014
Jan 15, 2014 at 04:08 PM
thanks but I need it broken down if you can. Is there any way you can give an example of were these go?
Thank you
Thank you
Ok, hang tight, I have faith you can do THIS!
You have to have the "Developer" tab enabled to get to Macros. Enable your sheet to accept VBA MACROS(depending on your version of O/S, let me know!).
You will cut and paste the above code into the sheet "general" tab. Once you get into VBA (visual Basic for Applications), you will see an index on left of sheet names, click worksheet. Once you click on worksheet, the page should change states, and allow you to write code, paste the code into the page, and push the "Play" key.
Test it out. IMPORTANT. what version of excel!
I am here for you!
Have fun!
//ark
-Moderator/Contributor
You have to have the "Developer" tab enabled to get to Macros. Enable your sheet to accept VBA MACROS(depending on your version of O/S, let me know!).
You will cut and paste the above code into the sheet "general" tab. Once you get into VBA (visual Basic for Applications), you will see an index on left of sheet names, click worksheet. Once you click on worksheet, the page should change states, and allow you to write code, paste the code into the page, and push the "Play" key.
Test it out. IMPORTANT. what version of excel!
I am here for you!
Have fun!
//ark
-Moderator/Contributor