Hi all,
Here I have a Gantt chart scheduler which is mainly controlled with ActiveX objects (listboxes, buttons, etc.). It is fully functional, but... I want all of those objects to be on a userform,what is easy and I have already drawn it to replicate all controls. But I really have no idea and knowledge make it function on a userform. Could anyone please help me adapting the vba codes from ActiveX to work on userform?
A million thanks!
See attached...
Hello ABSTRAKTUS,
I don't want to dampen your hopes for an answer. This is a VBA project, not just one or two macros that you need help with. It will take someone quite a bit of time to review and understand your code. It will take even longer because many of the macros are recorded and will need to re-written to make them more flexible, easier to read and maintain. Does not mean that someone won't take it on though.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
I don't expect a helper to do everything for me. With someone's minimum input I could do the rest by myself (renaming objects, assigning macros, copying the codes over, etc.)
Bump...........
bump...........
Is there anything specific you need help with?
If posting code please use code tags, see here.
I just do not understand why the code from ActiveX object cannot work on the same object on a userform. I do really need to move these codes to userform. Have been playing around for days now - no success...
What code/objects are you referring to?
What isn't working?
I just want all listboxes and buttons to be (and function) on a userform.
This is your workbook, can't you give a hint on what you want help with?
Is it with populating certain listboxes?
If it is, which listboxes and how should they be populated?
Ok. I want to have a Gantt chart scheduler on the excel worksheet as it is at the moment. But I want to control it from userform. Now I have 7 listboxes and 25 buttons on the worksheet. The big listbox is populated with the total list of products. Then I want to be able to move products to other listboxes where needed. And all movements I make within userform should update the worksheet in realtime.
Don't know if you had chance to look at the attached workbook. It is fully functional. I just don't want any objects on a excel worksheet. I want to call userform with those objects on and control excel worksheet from there.
I did look at the workbook, and tried figuring out what was happening.
Just seemed to get a whole bunch of errors, especially when trying to move items from the big listbox.
I did figure out how you can populate the listboxs on the userform.
Please Login or Register to view this content.
This one worked! Thanks. But there is still plenty to go... What about moving values from big listbox to any of the small ones? And moving values up/down within?
Try this for putting items in the PennyStacks listbox (ListBox1).
Please Login or Register to view this content.
I think you meant listbox2? Yes it works! What about up/down feature?
Why not give that a try yourself?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks