Consulting

Results 1 to 20 of 20

Thread: filling in cells in multiple spreadsheets?

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #2
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    Hi,

    Well this really depends on where you are going and what you are trying to do here. Some specifics would help. Maybe this will get you started ...

    Sub foo()
        Range("A1").Value = UserForm2.ComboBox1.Value
        Workbooks("Book1.xls").Worksheets("Sheet1").Range("A2").Value = UserForm2.TextBox1.Text
        Workbooks("Book2.xls").Worksheets("Sheet3").Range("A3").Value = UserForm2.TextBox2.Text
    End Sub

    If you need other help, just post back. Be sure and be as descriptive as possible when posting as this will get you the best possible help quicker.
    Last edited by Aussiebear; 04-19-2023 at 05:05 AM. Reason: Adjusted the code tags

Posting Permissions

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