ExcelBanter - Userform button setting variable from formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Userform button setting variable from formula (https://www.excelbanter.com/excel-discussion-misc-queries/62874-userform-button-setting-variable-formula.html)

teepee

Userform button setting variable from formula

I have a userform that contains windows media player. I want to set
CommandButton4 to take the value of the formula in cell A2 of the active
sheet and set it as the value of variable named 'inset'. I'm finding the VBA
code on this much harder to write than I thought it would be. Any ideas
please, anyone?

All times are GMT +1. The time now is 01:33 AM.