Hi guys,
I tried to create user form for my report in excel sheet not a user form in VBA code.
I try many code on the internet but it not match my expect.
Please see the detail below, and suggest me for the code.
This user form in the sheet name "EnterIn" the value is actually in the column B but I use center across selection.
B3= 11-Jan-2023
B4= CYL-004
B5= Operation gas
B6= Pure Oxygen (O2) 99.9995% min
B7= 5
B8= 20000
Value in B3-B8 will place in destination sheet base on header.
This sheet is the destination sheet with "InHistory" name.
Explanation:
After entry the data in B3-B8 then click SUBMIT button the data should go in to the destination sheet then clear the value in B3-B8.
The value should go only the value not a formular in cell.
This my starter code:
Thanks,
I tried to create user form for my report in excel sheet not a user form in VBA code.
I try many code on the internet but it not match my expect.
Please see the detail below, and suggest me for the code.
This user form in the sheet name "EnterIn" the value is actually in the column B but I use center across selection.
B3= 11-Jan-2023
B4= CYL-004
B5= Operation gas
B6= Pure Oxygen (O2) 99.9995% min
B7= 5
B8= 20000
Value in B3-B8 will place in destination sheet base on header.
This sheet is the destination sheet with "InHistory" name.
Explanation:
After entry the data in B3-B8 then click SUBMIT button the data should go in to the destination sheet then clear the value in B3-B8.
The value should go only the value not a formular in cell.
This my starter code:
VBA Code:
Public Sub EnterIn()
Dim wsEnterIN As Worksheet 'define source sheet
Set wsEnterIN = ThisWorkbook.Worksheets("EnterIn")
Dim wsInHistory As Worksheet 'define destination sheet
Set wsInHistory = ThisWorkbook.Worksheets("InHistory")
Dim DestRow As Long
DestRow = 6 'start in row 2 in destination sheet
End Sub
Thanks,