Variable User Input - Either a Fixed Input or Cell Reference

[bman100]

I would like to give a user the option of either inputting a fixed number or making reference to another worksheet, but all within one cell if possible. Therefore, it would be a decision first (do you want to input: 1) a fixed number or 2) utilize a reference to another worksheet that contains all the detail), and depending on the decision, the user inputs a number or the cell reference is input.

 

[jkpieterse]

Something like this should do it:

Sub GetCellValueOrRef()
    ActiveCell.FormulaR1C1 = Application.InputBox("Please enter a number or point to the cell with the number you wish to use", , , , , , , 0)
End Sub

 

[bman100]

Thanks jkpieterse. The code you sent was very instructive, but I wasn't very clear in my original post. I'm looking for a drop down where the use can first choose to input either a fixed number or can choose to utilize a reference to another cell (I will put this cell reference in the reference). I want to calculate costs and the user can either choose to plug in a number or can choose to select the reference (which is connected to another worksheet that has the detail). This is for a pro forma, and typically you enter a plug number initially and then later on you update the entry with detail (that can be set forth in the worksheet). I hope this help clarify.

Something like this should do it:

Sub GetCellValueOrRef()
    ActiveCell.FormulaR1C1 = Application.InputBox("Please enter a number or point to the cell with the number you wish to use", , , , , , , 0)
End Sub