Can't fire unusual populated Box?

[bralew]

Morning All,

Is it possible to execute a VBA code without being specific as to the contents. I already have the contents filled with correct information, I just require a particular ComboBox to activate something
as soon as itself becomes populated?

I'm trying to keep the maintenance as low as possible without being too complicated. It's proving challenging due to all the variables I'm juggling.
Excuse my limited code as I'm trying to identify the concept. Any help would be gratefully received.

Please Login or Register  to view this content.

[xlnitwit]

Good morning.

I'm not sure I follow that. Do you mean that when combobox7 changes, it should populate textbox47 only if combobox14 has something in it?

[bralew]

Yeah, that's it. So i recognises an activity rather than a specific detail. I've got the detail already. Head scratcher this one :-/

[xlnitwit]

Either of these should do the job

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[bralew]

Thanks man. I've been reflecting on you initial advice of improving the workflow. As more variables are introduced the more I find myself re-directing information. Very challenging Lol

I'll give this a whirl now

[bralew]

Got this, probably something I've done??

[xlnitwit]

I'd say either Textbox26 or Textbox47 (or both) is not numeric.

[bralew]

Your right, I've changed the code and it works. However, I'm back to my old conundrum whereby the focus want entered information as opposed to data which populates as a result of a VBA code.

I added the values:

Please Login or Register  to view this content.

It puts a 0 in the cell because it can't recognise the VBA input and prefers typed data. Is there any advice or should I look for another way? Unless, of course my addition is incorrect?

[xlnitwit]

What exactly is the VBA input?

[bralew]

It just says "STUBC012", but the reason why I wanted it to fire from any old population is because there's hundreds of them. If I've got to be specific with the data its horrendous maintenance as I'll be updating two areas of VBA as opposed to 1.

[xlnitwit]

I assume that is not in Textbox26 or Textbox47 since it isn't a number.

The only way that that VBA code will put 0 in Textbox47 is if the value in either of the two textboxes is blank, 0 or not numeric.

[bralew]

No mate, it populates ComboBox14 which receives its input from ComboBox7?

[xlnitwit]

I am aware that Combobox7 triggers the code and it then checks if Combobox14 is empty or not. If combobox14 is empty, the code doesn't do anything at all- it will not put a 0 anywhere. If combobox14 is empty, the code might put a 0 in textbox47 if the conditions I mentioned are true.

Combobox14 is not populated by this code.

[bralew]

Have a gander, I suspect there's an easier way but I'm buggered if I can think of it.

[xlnitwit]

An easier way to do what? It is not at all clear to me what exactly it is that you think should be happening here, I'm afraid.

[bralew]

Press Axle generator

select 54 SQ
select capacity 500
Select Hub - C


you'll see the stub box populate,

[xlnitwit]

I will need an answer to my last question first- there is little point in me reviewing the file if I don't know what it is supposed to be doing.

[Arkadi]

bralew,

You mentioned that "It puts a 0 in the cell because it can't recognise the VBA input and prefers typed data. Is there any advice or should I look for another way? Unless, of course my addition is incorrect?".
Where is the 0 being put exactly? From what I've been reading here xlnitwit provided what you wanted but it is rather hard to follow the conversation. Can you restate exactly and concisely what exactly you want to achieve? Also, having the workbook instead of some images might help us follow the logic better.

[bralew]

I'd like to select a Hub, say C, which will populate a box with the model which will then instantly give me the weight. It's easier on the other components but I don't know why

[Arkadi]

Ok well I can see that

Please Login or Register  to view this content.

puts 0 because Textbox 47 is blank so textbox 26 times 0 = 0. You are using Textbox47 to calculate its own value.

[bralew]

Ahh right, ComboBox14 is supposed to put a weight in there, If you change the quantity it works

[bralew]

apologies lads, i had my code in the wrong sub change, thank you , ill update while i still have cognition