title: Displaying Message box values in a cell
body: <p>Am new to VBA. So posting this question:</p>
  
  <p><strong>Requirement:</strong> I want to display my message box values in a cell.</p>
  
  <p><strong>For example:</strong> 
  <a href="https://i.stack.imgur.com/rx4XQ.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rx4XQ.jpg" alt="enter image description here"></a></p>
  
  <p>Below is my code: </p>
  
  <pre><code>Sub Button1_Click()
  
      MsgBox "value of a cell is" &amp; Worksheets("Sheet1").Range("A1")
  
  End Sub
  </code></pre>
  
  <p>When i click on the button it is displaying values for the cell A1 as below</p>
  
  <p><a href="https://i.stack.imgur.com/DpJbL.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DpJbL.jpg" alt="enter image description here"></a></p>
  
  <p>But i want the values from the message box to display on any cell.</p>
  
  <p>Lets say i want "value of a cell is 45" to be displayed on some other cell.</p>
  
  <p>Thanks in Advance.</p>