Notes

Hey guys. I am a junior year university student and as an Intern currently working on an excel macro to make some processes easier for users in our company. I don't have so much developing experience on excel VBA. Therefore, I have a question for you guys which is about excel VBA. Let me briefly explain the document. In "A" column, there are some supplier firm names which give offers to projects of our company. "PROJE ALT DALI" means that projects that our company is working on. In this case, I created an userform. In this userform, I want to put 'X' symbol to intersection of rows which belong to supplier firm names and column which belongs to the project. For instance, If "B firm" gives an offer to project "ALT_DALI_1", macro will put 'X' to the intersection point of this row and column which is "Q8" cell. Userform looks like this. In addition, I need to add a property to this userform which provides us adding new firms as many as we want. Maybe, a button can be created as "Add new firm" . When we press the button, another combobox would open in this Userform. With this method, users can just select second firm via combobox and pass the next firm if there is a third firm that gives an offer to our specific project. Since number of firms that give offers to our projects can change each time, we need to put this property. I realized that I didnt explain it clearly. However, If you want to help me, I can disturb you just via inbox.