Get input box value and store it as part of the codes in VBA editor

Question

Hello there,

Is it possible to get the value of the input box and put that value as part of the codes in VBA editor? For example in codes below. I want to get whatever vlookupformula entered in the input box, add the value as string inside Formula = “” . Just like javascript that you can manipulate the html elements, tags, attributes or attributes values by adding or removing. Thanks!

Dim wb As Workbook
Dim wbName As String

Set wb = Workbooks(1)
wbName = wb.name
wbName = InputBox(“Enter new vlookUp Formula”, wbName)

Formula = “”

End Sub

Answer 1

They're actively answering excel development questions in dedicated forums here.
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-msoffice_custom
https://social.msdn.microsoft.com/Forums/Lync/en-US/home?forum=exceldev

--please don't forget to Accept as answer if the reply is helpful--