How can I refer to any table column in a dynamic fashion:
For example, I have several fields in my table (tblSales) - Revenue and Cost. I want to be able to dynamically type in a field value in A1 that would automatically change the contents of the formula in A2.
Similar to the following...
I'm trying to copy and past an Excel Shape object to a VBA user form image but can't seem to figure it out.
The code I have so far is this:
Private Sub CommandButton4_Click()
Dim pic As Shape
Set pic = ActiveSheet.Shapes(ActiveSheet.Shapes.Count)
pic.CopyPicture xlScreen, xlBitmap...