Hi,
I have a code that selects a certain default "stub" when a certain "Hub" is selected. However, I sometimes wish to over ride this choice and choose a different
stub. How can I do this? Would I be right in thinking it would be some kind of "else" command?
Please Login or Register to view this content.
Couldn't you just select a different stub in ComboBox14 ?
Here's another way to write your existing code.
Please Login or Register to view this content.
Last edited by AlphaFrog; 10-11-2016 at 10:00 AM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thanks,
I've tried it but I've lost the capacity to populate my Stub box based on Hub choice (the Stub box was populated with default choice as soona as a choose Hub). I still want the default to populate the Stub box
but I'd like the capacity to overide it if I need to ?
I don't really follow what all that means. Why can't you select a value in the Stub combobox?Originally Posted by bralew
Otherwise, how is the code suppose to know when you want to override the default? What condition would exist that indicates you want to override the default that the code can test?
I know its complicated, I think I'm pushing the limits of VBA with this one
Basically, When I select Hub (combobox7) it chooses a stub (combobox14) and it populates and additional H factor box(combobox23) with a specific reading.
Sometimes the default stub for the hub, is not required and I have to choose another stub which will in turn give a new reading in combobox23.
It's not really that complicated. You just haven't taken the time to explain things.
When you choose a Hub, and the code chooses a Stub based on your Hub selection, why can you then pick a different Stub in Combobox14 and override the Stub selected by the code?
Can I show you? I'll upload the file
select 54 square on first userform and your in the main one.
select hub A and it will choose a stub
try and overide whilst preserving the changes
My head really hurt Lol
I choose Hub A and it chose STUBA001. Then I selected any Stub I want from the stub combobox.
did it fill the h-factor/ ill check now
Wonderful, thank you ever so much !!!!!! Sorry i missed it earlier on
Thanks
Very cryptic, but I think the answer is yes.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks