Results 1 to 4 of 4

Excel Userform Rowsource replacement with compatibility for PC/MAC

Threaded View

Rigormorpheus1 Excel Userform Rowsource... 12-04-2018, 12:33 AM
AlphaFrog Re: Excel Userform Rowsource... 12-04-2018, 12:58 AM
Rigormorpheus1 Re: Excel Userform Rowsource... 12-04-2018, 01:06 AM
AlphaFrog Re: Excel Userform Rowsource... 12-04-2018, 01:13 AM
  1. #1
    Registered User
    Join Date
    12-03-2018
    Location
    Utah, USA
    MS-Off Ver
    Office 365
    Posts
    3

    Excel Userform Rowsource replacement with compatibility for PC/MAC

    I am trying to modify a workbook that works fine on PC to work on Mac, unfortunately it does use a rowsource call which does not work on mac. I have tried all the alternative solutions I have found here and on other sites and none of them work. Most will just return an Error 13 invalid property.

    Here is the code I'm using that works for the pc to load the userform:

    Private Sub UserForm_Initialize()
        LstEncounters.ColumnCount = 61
        LstEncounters.ColumnWidths = "70,55,14,55,14,55,14,55,14,55,14,55,14,55,14,55,14,55,14,55,14,55,14,55,14,55,14,55,14,55,14,55,14,55,14,55,14,55,14,55,14,55,14,55,14,55,14,55,14,55,14,55,14,55,14,55,14,55,14,55,14"
        LstEncounters.ColumnHeads = True
        LstEncounters.RowSource = "SavedEncounters"
    End Sub
    "SavedEncounters" is a workbook named range.

    This should bring up a box that shows the cell information on a seperate worksheet that I can click on a row of data and hit load to populate another worksheet.

    If I comment out the "LstEncounters.Rowsource" line the box shows but of course is empty. I have attached an example file, to launch the code causing the error on the "Encounter Builder" sheet click on View/Load button.

    Any insight or ideas would be a great help. I have tried to use the list command but it is not working either.
    Attached Files Attached Files
    Last edited by Rigormorpheus1; 12-04-2018 at 01:08 AM. Reason: Issue Resolved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Listbox Rowsource set when userform opened
    By PFDave in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-23-2016, 05:58 AM
  2. Using Array as Rowsource in Userform
    By jwolfenstein in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-05-2016, 01:02 PM
  3. [SOLVED] Userform RowSource
    By plans in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-12-2015, 11:46 AM
  4. [SOLVED] Userform and Rowsource
    By saban1974 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-06-2014, 12:44 PM
  5. UserForm -> Combobox and it's RowSource property?
    By CEC in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-02-2013, 02:16 PM
  6. ???Help??? Userform.Listbox.rowsource = ???
    By Steve Sparti in forum Excel General
    Replies: 0
    Last Post: 03-01-2006, 05:50 PM
  7. [SOLVED] UserForm ComboBox RowSource Problem
    By Minitman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-04-2006, 01:25 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1