excel vba - VBA Dependent Combobox -

-

i have 3 combo boxes dependent each other. list on cmb2 depends on value on cmb1. cmb3 list depends on cmb2 value.

my problem is, when remove/delete values on combo boxes, when click cmb2, still shows list of last value chosen on cmb1 & same goes cmb3.

what's code show empty if combo box it's dependent doesn't have value?

edit: think based on added information in comment should encapsulate logic in sub procedures , functions. best so, there should logic between named ranges , values in combobox.

in below example, created function handle conversions value in independent combobox , named ranges. can supply own connector, assumed space changed underscore (so, 'account information' replaced 'account_information').

next subprocedure checks confirm named range exists in workbook matches converted value in independent combobox. if so, dependent box takes on named range list property. if not, dependent combobox cleared.

the benefit using type of system repeated other comboboxes without rewriting code. see below code , let know if need added help.

private sub userform_initialize()     me.combobox1         .additem "account information"         .additem "other stuff"     end end sub private sub combobox1_change()     me         loaddependentcbo me.combobox1, me.combobox2     end end sub  private function convertvaluetonamedrange(svalue string, sconnector string) string     'this function takes values in combobox , converts them named ranges     'the spaces replaced whichever connector supplied function     'note: created separate function though uses built-in function     'in case more implementation code needed      convertvaluetonamedrange = replace(svalue, " ", sconnector) end function  private sub loaddependentcbo(cboindependent combobox, cbodependent combobox)     'this code looks see if there match between value of independent combobox     'and named range in workbook. if not, dependent combobox set empty      dim stemp string     dim rnamedrange range      stemp = ""     on error resume next         stemp = names.item(convertvaluetonamedrange(cboindependent.value, "_")).name     on error goto 0      if stemp = ""         'there no matching named range clear dependent combobox         cbodependent.clear     else         cbodependent.list = range(stemp).value     end if end sub

old post: code combobox1.listindex = -1 set combo box empty (change name of box suit). logic depends on more details. let know if need implementation.


Comments

Post a Comment

Popular posts from this blog

Django REST Framework perform_create: You cannot call `.save()` after accessing `serializer.data` -

-
i have following viewset: class artistprofileviewset(viewsets.modelviewset): queryset = artistprofile.objects.all() serializer_class = artistprofileserializer def perform_create(self, serializer): if serializer.is_valid(): serializer.save() with following serializers: class simpleartisttrackserializer(serializers.hyperlinkedmodelserializer): class meta: model = artisttrack fields = (...my fields...) class artistprofileserializer(serializers.hyperlinkedmodelserializer): owners = userserializer(many=true, required=false) tracks = simpleartisttrackserializer(many=true, required=false) class meta: model = artistprofile fields = (...my fields...) i getting following error: assertionerror: cannot call `.save()` after accessing `serializer.data`.if need access data before committing database inspect 'serializer.validated_data' instead. i don't see editing serializer.data object. th...
Read more

Why does Go error when trying to marshal this JSON? -

-
i'm trying rather simple example of trying decode json file structs using golang. however, when attempting error that json: cannot unmarshal object go value of type []main.track which don't understand. here's code in question, , json can found here . package main import ( "encoding/json" "fmt" "net/http" "os" ) // tracks group of track types type tracks struct { tracks []track } // track represents singular track type track struct { name string url string artist artist } // artist represents single artist type artist struct { name string mbid string url string } func main() { url := "http://ws.audioscrobbler.com/2.0/?method=geo.gettoptracks&api_key=c1572082105bd40d247836b5c1819623&format=json&country=netherlands" response, err := http.get(url) if err != nil { fmt.printf("%s\n", err) os.exit(1) } de...
Read more