In my procedure I save the value of a lookup data item as the name of a button.
ie.
member = Worksheets("Current Members").Cells(c, 1)
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; color: #000000 ; background-color: #ffffff}span.s1 {color: #011993}</style>With btn
.OnAction = "A02_AddAMember"
.Caption = member
.Name = "Btn" & 8
End With
Now I want to save the .caption value to another variable in another sub
ie. member2 = .caption value
But I cannot figure out how to do this.
Can anyone help me out?
ie.
member = Worksheets("Current Members").Cells(c, 1)
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; color: #000000 ; background-color: #ffffff}span.s1 {color: #011993}</style>With btn
.OnAction = "A02_AddAMember"
.Caption = member
.Name = "Btn" & 8
End With
Now I want to save the .caption value to another variable in another sub
ie. member2 = .caption value
But I cannot figure out how to do this.
Can anyone help me out?