Results 1 to 17 of 17

Thread: Dynamic range that change variables

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 02-26-2012, 12:19 PM #7
    mdmackillop
    mdmackillop is offline
    Administrator
    VP-Knowledge Base     VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,476
    Location
    Private Sub ComboBox1_Change()
    Dim r As Range
    Set r = Columns(1).Find(ComboBox1).Resize(, 3)
    Label6.Caption = r(1)
    Label7.Caption = r(2)
    Label8.Caption = r(3)
End Sub
    Last edited by Aussiebear; 03-27-2025 at 02:48 AM.
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.

    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules