Hi Guys,
I'm a complete novice at anything VBA. I've been reading and reading threads on this site and others to be able to understand it a little better. Anyway on the project I'm doing at the moment it would be really nice to have a drop down menu to be able to select materials for a mix. I can use the standard factorytalk SE List boxes but they are not very aesthetically pleasing.
What I'd like to use is the ActiveX combobox. I have been trying to get this to work but it has beaten me so far. I can populate the drop down menu's with standard text singularly no problem and also populate with arrays using the .list command, but I'd really like to direct reference tags in my plc (compactlogix) so these drop down lists change with the plc data. I've come across posts where people direct reference micrologix plc tags and have tried to copy this method by placing a tag similar to the following in place {[Compactlogix process]Sample_tag]}. However the VBA system doesn't like the outside brackets unless I put quotation marks at either side in which case it displays the text inside the quotation marks. It's Very frustrating and I'm sure perfectly simple to seasoned VBA guys.
I have absolutely no experience with VBA of any kind or other similar programming software so please any help is appreciated.
thanks
Jonny
I'm a complete novice at anything VBA. I've been reading and reading threads on this site and others to be able to understand it a little better. Anyway on the project I'm doing at the moment it would be really nice to have a drop down menu to be able to select materials for a mix. I can use the standard factorytalk SE List boxes but they are not very aesthetically pleasing.
What I'd like to use is the ActiveX combobox. I have been trying to get this to work but it has beaten me so far. I can populate the drop down menu's with standard text singularly no problem and also populate with arrays using the .list command, but I'd really like to direct reference tags in my plc (compactlogix) so these drop down lists change with the plc data. I've come across posts where people direct reference micrologix plc tags and have tried to copy this method by placing a tag similar to the following in place {[Compactlogix process]Sample_tag]}. However the VBA system doesn't like the outside brackets unless I put quotation marks at either side in which case it displays the text inside the quotation marks. It's Very frustrating and I'm sure perfectly simple to seasoned VBA guys.
I have absolutely no experience with VBA of any kind or other similar programming software so please any help is appreciated.
thanks
Jonny