Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Fill textbox from Combobox

  1. #1
    Join Date
    25th January 2003
    Location
    Scotland
    Posts
    1,462

    Fill textbox from Combobox

    Hi All,

    I have a User Form and I am trying to fill the controls using the columns of a Combobox. Combobox cbMake has 3 columns, bound column 1. I need the textbox to be equal to the value of the second column when the Combobox changes

    VB:
    Private Sub cbMake_Change() 
        Me.txPerc.Value = Format(Me.cbMake.Column(1),"#0.0%") 
    End Sub 
    
    
    I get the error:
    'Could not get the column property'
    'Invalid property array index'

    Can anyone help me here please?

    Bill

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    14th July 2004
    Posts
    10,539

    Re: Fill textbox from Combobox

    Bill

    Can you attach a sample workbook?

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    25th January 2003
    Location
    Scotland
    Posts
    1,462

    Re: Fill textbox from Combobox

    Hi Norie,

    Sorry, I think I am trying to use an Access code in Excel here. I have changed it to a VLookup formula and it is working fine.

    Sorry for any trouble.

    Bill

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    14th July 2004
    Posts
    10,539

    Re: Fill textbox from Combobox

    Bill

    Comboboxes, though different, in Access and Excel would both use Column like that as far as I recall.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    4th November 2010
    Posts
    3

    Re: Fill textbox from Combobox

    @ranger

    can u tell me how to use vlookup formula in vba?

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Fill TextBox Based On ComboBox Choice
    By ragha81 in forum EXCEL HELP
    Replies: 8
    Last Post: February 7th, 2008, 23:55
  2. Fill Textbox Based On ComboBox Selection
    By rex.morgan in forum EXCEL HELP
    Replies: 4
    Last Post: January 5th, 2008, 11:19
  3. Fill Textbox With Info From Combobox
    By dcorbin in forum EXCEL HELP
    Replies: 4
    Last Post: July 31st, 2007, 05:02
  4. Fill Cells Matching ComboBox With TextBox
    By buckchow in forum EXCEL HELP
    Replies: 6
    Last Post: January 3rd, 2007, 13:15
  5. Fill TextBox With Offset From ComboBox Choice
    By camealion in forum EXCEL HELP
    Replies: 6
    Last Post: November 20th, 2006, 04:28

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
  •  
porno