Auto Selection of Combo Box from Text Box value in Activecell Row

[nandhavnk]

Hi

I have tried coding in Worksheet Edit Command button. I can't complete it.

For Edit Button Click, I unable to do coding,

What I expecting here is,
By Clicking Worksheet Edit Button, User form Open with activecell row values in Text boxes & auto selecting respective titles.

E.g,

ActiveCell Row #10
Order No: 5(Column A) and populate in txtordn = 0005
Active row range from E:AX, total non blanks is 7. So activate all combo boxes and textboxes. If non blanks cells is 4 means activate 4 comb boxes & textboxes.

Active row range from E:AX
txtitem1 = 55 (1st Non Blank cells value)
txtitem2 = 55 (2nd Non Blank cells value)
txtitem3 = 55 (3rd Non Blank cells value)
txtitem4 = 55 (4th Non Blank cells value)
txtitem5 = 55 (5th Non Blank cells value)
txtitem6 = 55 (6th Non Blank cells value)
txtitem7 = 55 (7th Non Blank cells value)

Active row range from E:AX
cbitem1 = Item#2 (Autoselection)
cbitem2 = Item#9 (Autoselection)
cbitem3 = Item#10 (Autoselection)
cbitem4 = Item#14 (Autoselection)
cbitem5 = Item#16 (Autoselection)
cbitem6 = Item#19 (Autoselection)
cbitem7 = Item#21 (Autoselection)

Once click update button in userform, it will amend in the activecell row #10.

I request experts look into my sample file and give me proper coding. Combo AutoSelection

Thanks in advance

 

[nandhavnk]

Hi

I have tried coding in Worksheet Edit Command button. I can't complete it.

For Edit Button Click, I unable to do coding,

What I expecting here is,
By Clicking Worksheet Edit Button, User form Open with activecell row values in Text boxes & auto selecting respective titles.

E.g,

ActiveCell Row #10
Order No: 5(Column A) and populate in txtordn = 0005
Active row range from E:AX, total non blanks is 7. So activate all combo boxes and textboxes. If non blanks cells is 4 means activate 4 comb boxes & textboxes.

Active row range from E:AX
txtitem1 = 55 (1st Non Blank cells value)
txtitem2 = 55 (2nd Non Blank cells value)
txtitem3 = 55 (3rd Non Blank cells value)
txtitem4 = 55 (4th Non Blank cells value)
txtitem5 = 55 (5th Non Blank cells value)
txtitem6 = 55 (6th Non Blank cells value)
txtitem7 = 55 (7th Non Blank cells value)

Active row range from E:AX
cbitem1 = Item#2 (Autoselection)
cbitem2 = Item#9 (Autoselection)
cbitem3 = Item#10 (Autoselection)
cbitem4 = Item#14 (Autoselection)
cbitem5 = Item#16 (Autoselection)
cbitem6 = Item#19 (Autoselection)
cbitem7 = Item#21 (Autoselection)

Once click update button in userform, it will amend in the activecell row #10.

I request experts look into my sample file and give me proper coding. Combo AutoSelection

Thanks in advance

Hi,

Could someone guide me to do coding?

Thanks