+ Reply to Thread
Results 1 to 3 of 3

Access combobox controls in worksheet - Getting runtime error '438'

  1. #1
    Registered User
    Join Date
    12-31-2015
    Location
    Dallas
    MS-Off Ver
    2013
    Posts
    4

    Access combobox controls in worksheet - Getting runtime error '438'

    I have defined a global variable array in standard module. Defined 4 combo boxes in a worksheet (Sheet1) as Combobox1, Combobox 2 etc...

    I am trying to access the combobox controls dynamically within a function in the worksheet (Sheet1) but I keep getting runtime error '438'. Object does not support property/method.

    Can anyone suggest what am I missing?

    Thanks in advance.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Access combobox controls in worksheet - Getting runtime error '438'

    Hi Padala and welcome to ExcelForum,

    Thank you for using Code Tags.

    There are two types of controls on a SpreadSheet:
    a. Forms Controls, and
    b. Active X Controls

    For a discussion of the difference between the two see: http://www.excelforum.com/excel-prog...ml#post3880991

    You seem to have an 'Active X' control and are using Forms Control Syntax:

    Typical 'Active X' Syntax (typically no spaces in the name):
    Please Login or Register  to view this content.
    Typical 'Forms Control Syntax (typically lots of spaces in the name:
    Please Login or Register  to view this content.
    I hope this helps.

    Lewis

  3. #3
    Registered User
    Join Date
    12-31-2015
    Location
    Dallas
    MS-Off Ver
    2013
    Posts
    4

    Re: Access combobox controls in worksheet - Getting runtime error '438'

    Thanks LJM.. That was it...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Mac generating Runtime Error 380 when loading Range into Combobox
    By Ochimus in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-14-2015, 07:16 PM
  2. Replies: 1
    Last Post: 09-05-2013, 10:12 AM
  3. Excel - Access 1004 Runtime Error PLEASE HELP!!!
    By jamesgarf in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-12-2012, 01:59 PM
  4. Cascading ComboBox Runtime Error
    By baisty182 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-02-2010, 11:28 AM
  5. Runtime error '1004': cannot access...
    By rsford31 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2010, 03:58 PM
  6. Runtime Error 80040e10 Excel VBA MS Access
    By cnerurkar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-26-2007, 10:39 AM
  7. runtime error: syntax error or access violation
    By oucsester in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-03-2006, 12:55 PM

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