Look to find a formul that will make an item rec
Closed
rwarren445
Posts
2
Registration date
Monday January 13, 2014
Status
Member
Last seen
January 15, 2014
-
Jan 13, 2014 at 03:14 PM
Blocked Profile - Jan 15, 2014 at 05:30 PM
Blocked Profile - Jan 15, 2014 at 05:30 PM
Related:
- Look to find a formul that will make an item rec
- Every item in little alchemy - Guide
- Pokemon fire red item cheats - Guide
- How to disable recover deleted items in outlook mail - Guide
- Free fire item generator - Guide
- Hi-q mp3 rec (free) - Download - Audio recording
3 responses
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
Posts
2
Registration date
Monday January 13, 2014
Status
Member
Last seen
January 15, 2014
Jan 15, 2014 at 04:08 PM
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
