Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Fill textbox from Combobox

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

    Code:
    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

  • #2
    Re: Fill textbox from Combobox

    Bill

    Can you attach a sample workbook?
    Boo!

    Comment


    • #3
      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

      Comment


      • #4
        Re: Fill textbox from Combobox

        Bill

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

        Comment


        • #5
          Re: Fill textbox from Combobox

          @ranger

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

          Comment

          Trending

          Collapse

          There are no results that meet this criteria.

          Working...
          X