Command Button press to put data in UserForm to specific cell

[andycrowh]

Hi there,

I have a VBA Userform, when the command button is pressed the data inserted into the UserForm needs to be placed in specific cells within the workbook.

Sheet name - Sheet3 (Template)

Textbox1 to B5 and C59
Textbox2 to D59
Textbox3 to C62
Textbox4 to D62
Textbox5 to D7
Textbox6 to F7

I have a column (B) where it will insert the value from D7 as a date and the column to the left (A) shows the day, if the cell in column B is empty I want column A to not show anything

 

[alansidman]

Range("B5") = Me.Textbox1
Range("C59")= Me.Textbox1
etc.

In Column A =if(A2="", "", B2) and format as appropriately using Custom Format

 

[andycrowh]

Thanks Alan, so the formula already is =TEXT(B9,"dddd") what would I type to say if B9 is blank then show nothing?