Mouse to Define Variable

  • Thread starter Thread starter MAS
  • Start date Start date
M

MAS

Hi,

Just taking my first steps back to VBA..

I want to prompt users to click on a staff members name in a worksheet and
assign the result of that mouse click to the variable StaffName.

Please point me in the direction of the correct Function.
 
MAS,

Sub TryNow()
Dim StaffName As String

StaffName = Application.InputBox( _
"Select the cell with the Staffer's Name", _
"Select the Name", , , , , , 8).Value

MsgBox StaffName

End Sub

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Unable to use mouse for scrolling 5
How do you populate a listbox based on a combo box selection in ms access? 1
Variable to rename a tab in a worksheet via VBA 5
create defined name using variable file name in reference 3
Assign Selection to a Variable 2
How to use VBA variable in COUNTIF function? 10
INDIRECT lookup of sheet names 4
Create Range by joining multiple Ranges - passing multiple holidayranges to Workday function 6

Back
Top