Excel Macro

G

Guitora Kuronato

Joined
Jan 10, 2013
Messages
1
Reaction score
0
Hallo all,,
I was new for excel macro..

So now i would like to ask.
what the code i need to write for the save button just like the image below

If i click on the SAVE button, then the value of the TEXTBOX (Part No) will get search product text and match of the date of day today. Then from the cells that match product value + date will get fill in the value of the QTY

just like the picture,, cell G4
fill by 5..
Cause match of A4 (TTT2224) and made of today date G1(6)

can anyone help me?
 

Attachments

  • Untitled.webp
    Untitled.webp
    82.6 KB · Views: 203
Guitora,

I don't completely understand what your goal is so I can't give you working code but I think I can point you in the right direction.

The ".Find" method will help you find a matching value to your Product No. field. The contents of that field may be referenced as the search value; you will need to use the name of the control (find this in the properties window) so it will be something like "controlname.value". That also applies to the part about the QTY field.

There is a built-in function for today's date in VBA, which is called "Date." Usage looks something like "Cells(1,1) = Date."

I hope that helps...
 
Back
Top