VBA Command Button insert formula

jledlow · Apr 26th 2016

I am trying to have a command button insert a formula into a group of merged cells when clicked.
Attached is the sample excel file.
When Name1 button is clicked I would like it to insert the formula that is currently in b2:d3.
Thanks for any help.

skywriter · Apr 26th 2016

Re: VBA Command Button insert formula

Try this. :cool:

Code

Sub Button1_Click()
    Selection.Formula = "=" & """NAME1 """ & "&""" & "{""" & "&" & "TEXT(TODAY(),""" & _
    "mm/dd/yyyy" & """" & ")" & "&" & """}"""
End Sub

jledlow · Apr 27th 2016

Re: VBA Command Button insert formula

Thanks skywriter, that worked. All the quotes and "&" is where I was going wrong.

skywriter · Apr 27th 2016

Re: VBA Command Button insert formula

My pleasure, thanks for the feedback. :cool:

VBA Command Button insert formula

Participate now!

Share