title: Setting Button Location for Macro that Generates Form Control Buttons
body: <p>I currently have data that I am splitting into multiple sheets and allowing the user to select which sheet they run the macro on. The work sheet is used as a filtration between multiple systems</p>
  
  <p>I have a named range (dayList) that groups the data into days, and creates a new sheet for each day (day1, day2, etc). Each sheet must then have another macro applied (screen data) that will filter the data in each of these sheets in exactly the same way.</p>
  
  <p>I am trying to create a UI that will approximate the user being able to click on one of the cells in the named range to run the macro for that particular day. The code snippet im currently working with is below. </p>
  
  <pre><code> Sheets("LaunchScreen").Activate
      Cells(rowCounter, 6).Value = "Day" &amp; dayCounter
      ActiveSheet.Buttons.Add(538.5, 56.25, 48.75, 13.5).Name = "Day" &amp; dayCounter
      ActiveSheet.Buttons("Day" &amp; dayCounter).Select
      Selection.OnAction = "JoinTransactionAndFMMS"
  </code></pre>
  
  <p>Im looping this to create a new button for each day then pass the button name to another macro as a parameter to find the worksheet in this workbook that shares the same name.</p>
  
  <p>TLDR: I need to:</p>
  
  <ol>
  <li>Set the location of a button using VBA, preferably matching location to a cell reference e.g.
  <code> Range("A1").Button.Insert </code></li>
  <li>Pass a cell reference from a named range into a macro</li>
  </ol>
  
  <p>An excel noob in way over his head here. Any help would be greatly appreciated!</p>