Look to find a formul that will make an item recClosed

Question

Hello I am looking to track items received...  I would like to build a box were we enter the NSN and the amount of the items...   Date auto populate.   


NSN (Item number)   
Amount

Then it will auto populate into my spread sheet.

Thanks for any help.

ac3mark · Answer

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

rwarren445 · Answer

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

ac3mark · Answer

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

Look to find a formul that will make an item rec

3 replies

Subscribe To Our Newsletter!