VBA - Userform Question

[KadeFoster]

Hey all,

Been a while since I have been here. Have had no projects at work to do. But at the moment I am working on a VBA Userform project and basically have to teach myself how to do it, or learn how to use other peoples code and modify it to my needs.

Any ways i am kinda stumped. On my Userform (CheckScaleForm) I have 3 list boxes that show my data. On double click selection, that data repopulates my other fields, then i fill in a textbox to create an update for that task on another Sheet with all my update entries. I want my Status Combo selection to update the Status Cell from the double click selection but the rest of the update to go to the updates sheet (this code is working).

I have managed to get myself most of the way through the project but this idea has me beat. Any help would be awesome.

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: VBA - Edit cell of selected listbox row - OzGrid Free Excel/VBA Help Forum
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.