Afternoon everyone,
I'm really struggling to figure out what is going on now. I've tried to create an excel document that will act as a job tracker throughout various phases of construction. The initial worksheet layout is based on shapes used as tabs, which determine which columns are visible when clicked from a VBA Module. (Unhide All Columns to review)
From there, I've inserted 3 ActivX ComboBoxes that are meant to be used as alternative search fields. The user will rarely have/know all three of the values so I want to make sure they can populate all of the available data by using one of these 3. I initially attempted to use 3 option buttons that would alternate linkedcell and rowsource via macro, but that started to get funky. For now, I'm stalled at the ComboBox1_Change event and haven't proceeded with the other two in VBA . When the combobox1_change event starts, the other two comboboxes are hidden and textboxes are visible instead, and will populate with the related data.
When the ComboBoxes are selected and the user starts typing, the rowsource is formula driven based on what is typed, and eliminates all options not containing the data typed, dynamically reducing the dropdown list. Extra columns were added to generate this effect and those in-cell formulas can be found in their respective "If found, Frequency, & Searchable List" columns.
The current data range begins with Column FV and extends through NE
This whole setup feels like a frankenstein of all sorts of approaches and now when I type in ComboBox1, excel crashes. Yesterday morning I had only 5 Dim'd ranges in the ComboBox1_Change macro and I was able to get the dynamic dropdown.
All dim'd ranges are tied to their respective named ranges found in the name manager. This may be uneccesary or overkill and maybe a table is needed instead?
Right now I think I just need someone to tell me what the heck I'm doing wrong, and point me in the right direction. I'm a VBA novice and have scrapped together what I have from various google results, and tutorials that I could find. Some of the Macros were tailored to fit my needs and may just be too much for Excel to process?
I may need some advice on which sub events I should be assigning certain macros to eliminate the current headache.
Some additional observations:
There are three command buttons on the worksheet. (Add entry, Update Entry, and Clear Fields.) Add entry brings up a userform that works. Clear Entry clears all combobox values which then clears the dependant textboxes. Update Command Button is not yet programmed.
Not able to get date values to populate as dates in the linked textboxes. I don't see how to format the textbox values to reflect this format.
If I start typing "R" for "RDHA" the dropdown list seems unaffected. However, if I start to type "N" for "NWHL", excel crashes when I type N every time. I haven't gone through the alphabet, but I wonder if there is some significance to that...
*edit* - I've now cycled through the entire alphabet, as well as numerals and only two letters cause an immediate crash of Excel. "N" and "S"... this occurs as a first letter and as a secondary letter.
These are the current Worksheet Macros I have at a glance
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks