Blog Archives

Active cell as input to formula

=CELL("address") This brings the selected cell reference. Use the INDIRECT function do do whatever you want with it from there on. Note that simply selecting a cell won’t trigger the change. Once you select a cell, press F9 to calculate

Posted in Excel Formulas Tagged with: , , , ,

Gather User Data/Input via an InputBox

There are many times in Excel VBA that we are required to gather information from a user. Probably the most frequent method of doing is via a message box, that is; Sub UserInput() Dim iReply As Integer iReply = MsgBox(Prompt:="Do

Posted in VBA Snippets Tagged with: , , , , , , , ,