I can't modify code to emulate contents of ComboBox??????????

**bralew** · 11-07-2016, 08:46 AM

Hi All,

I have this code:

Private Sub ComboBox29_Change()

 If Me.ComboBox29.Value = "DPARM001" Then
    Me.ComboBox30.Value = "DPARM001"
    End If
    
    End Sub

However, rather than have a case or an If arrangement, which will lead to high maintenance, is there a method by which ComboBox30 will emulate what is input into ComboBox29?

**xlnitwit** · 11-07-2016, 08:49 AM

A simple assignment should suffice

Private Sub ComboBox29_Change()

    Me.ComboBox30.Value = Me.ComboBox29.Value

End Sub

**bralew** · 11-07-2016, 08:59 AM

Great Thank You, wish I'd realised this earlier Lol

I can't modify code to emulate contents of ComboBox??????????

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

I can't modify code to emulate contents of ComboBox??????????

Re: I can't modify code to emulate contents of ComboBox??????????

Re: I can't modify code to emulate contents of ComboBox??????????

Thread Information

Users Browsing this Thread

Similar Threads

How do I modify current code to limit the number of rows/columns my table of contents do

[SOLVED] Modify contents of cells

Populate combobox dependent on contents of previous combobox

VBA code to find and delete cell contents based on userform combobox selections

Modify code to drag cell contents across a row range

Modify code VBA to copy contents only, not formula

Modify code to hide rows based on the contents in a cell.

Bookmarks

Bookmarks

Posting Permissions