jeanstp
05-01-2017, 07:50 AM
Hi everyone,
I am working on a piece of VBA code to pop an InputBox to user if cell value in same row changes to "lost". The result would be that ACtive Cell would take the entered value by user in Input Box.
This is where I am with code
Function MyFunction(scellule As Range) As String
Dim sMycell As String
If MyFunction = "lost" Then
Set sMycell = Application.InputBox("Please enter lowest bidder amount")
ActiveCell.value = MyFunction.sMycell
Else
Exit Function
End Function
I am working on a piece of VBA code to pop an InputBox to user if cell value in same row changes to "lost". The result would be that ACtive Cell would take the entered value by user in Input Box.
This is where I am with code
Function MyFunction(scellule As Range) As String
Dim sMycell As String
If MyFunction = "lost" Then
Set sMycell = Application.InputBox("Please enter lowest bidder amount")
ActiveCell.value = MyFunction.sMycell
Else
Exit Function
End Function