double click - Listbox DoubleClick Event Issue

Question

I am a stuck I have a Listbox that I am trying update cells in worksheet range as well as other control objects (e.g. textbox.value, spinbutton.value, etc.) It was working fine for a bit, but suddenly it stopped allowing me to edit the linked data. When I double click an item in the event, it flashes briefing like it is enabled, but the immediately disables ..even though I don't have ListBox.Enabled = False anywhere. And here's the kicker, if I add one line of code MsgBox "Test" it leaves it active and I can update my text. This is probably a no-brainer issue for the gurus on the site, but I am new and I have no idea what I am doing wrong. Please Help!

question from:https://stackoverflow.com/questions/65649251/listbox-doubleclick-event-issue

Answer 1

Waitting for answers