excel vba - VBA - Preselecting Userform Listbox values matched from a string separated by commas -


1) have column of data fills multiselect listbox in userform. values days of week "monday" - "sunday"

dim listssheet worksheet dim lastrow long dim acell range  set listssheet = sheets("lists") listssheet     'fills days     lastrow = .cells(.rows.count, "a").end(xlup).row     each acell in .range("a2:a" & lastrow)         if acell.value <> ""         me.day.additem acell.value         end if     next

2) i'm able gather multi-selected values , transfer worksheet manipulation. assuming user selected days "tuesday" + "wednesday", data in cells = "tuesday, wednesday"

3) i'm attempting recreate listbox selected user. able use .additem generate list of days again, i'm unsure how go selecting correct .listindex value based on initial selection

the selection make in listbox recorded in zero-based boolean array has many elements listbox has items. array accessible listbox's read/write selected property. in case listbox1.selected(0) refers "monday" , listbox1.selected(6) sunday.

listbox1.selected(0) true or false depending upon whether monday selected or not. can read property when close form , re-establish same setting setting listbox1.selected(0) = true (or false) when show form again.

since have weekday names in a2:a8 might write selected() array b2:b8 in real time using listbox1_change event, , use range both on sheet , reset listbox.

by way, way of setting list isn't efficient. one, want 7 items in list. therefore 

lastrow = .cells(.rows.count, "a").end(xlup).row

will cause more mistakes prevents. another, excel's vba has provided rowsource property. can set list setting property. both following examples correct.

listbox1.rowsource = activesheet.range("a2:a8").address listbox1.rowsource = "dayslist"     ' dayslist named range

the use of activesheet safe if call form worksheet , therefore know 1 active @ time. or can apply array directly list property, this:-

listbox1.list = split("mon tue wed thu fri sat sun", " ")

Comments

Post a Comment

Popular posts from this blog

c# - Update a combobox from a presenter (MVP) -

i using mvp in project, new in mvp. have 2 comboboxes. when select option in combobox, combobox should filled new data. this action in presenter. view 'view1' in presenter, , introduced combobox1 , combobox2 properties in 'view1', because need 'datasource', 'displaymember', 'valuemember' , 'refresh()' in method below. but, when using pattern, enough send property like public string combobox2 { { return combobox1.selectedvalue.tosstring(); } } into presenter not whole combobox. how can solve problem? public void onselectedindexchangedcombobox1() { if (view1.combobox1.selectedindex == -1) { return; } datatable dt = tools.getdatatable("a path"); var query = (from o in dt.asenumerable() o.field<string>("afield") == farmerview.combobox1.selectedvalue.tostring() orderby o.field<string>("anotherfield") select...
Read more

How to understand 2 main() functions after using uftrace to profile the C++ program? -

i trying uftrace profile following simple c++ program: #include <iostream> class { public: a() {std::cout << "a created" << std::endl;} ~a() {std::cout << "a destroyed" << std::endl;} }; int main() { a; return 0; } the profile result this: # uftrace a.out created destroyed # duration tid function 2.026 [ 4828] | __cxa_atexit(); [ 4828] | main() { [ 4828] | __static_initialization_and_destruction_0() { 89.397 [ 4828] | std::ios_base::init::init(); 0.768 [ 4828] | __cxa_atexit(); 93.029 [ 4828] | } /* __static_initialization_and_destruction_0 */ 94.425 [ 4828] | } /* main */ [ 4828] | main() { [ 4828] | a::a() { 11.104 [ 4828] | std::operator <<(); 10.825 [ 4828] | std::basic_ostream::operator <<(); 24.514 [ 4828] | } /* a::a */ [ 4828] | a::~a() { 0.978 [ 4828] | ...
Read more

How to put a lock and transaction on table using spring 4 or above using jdbcTemplate and annotations like @Transactional? -

i trying put lock on table while writing on table , if happened in between roll-back . trying convert below code lock table test_g1 read; lock table test_g write; -- begin; start transaction; insert test_g1 values(143); insert test_g values(145); select * test_g1; select * test_g; rollback; select * test_g; unlock tables; how convert above code @transactional spring jdbctemplate code? @transactional(rollbackfor={dataaccessexception.class}) public void test(){ jdbctemplate.execute("insert test1 (id, nam) values (4, 'a')"); throw new dataaccessexception("error") { }; } here trying throw error, insert statement should rollback it's not happening . thanks edit-1 attaching code , doing in jdbcdaoimpl.java , mentioned problem comment above test() . app.java package com.cgiri.javabrains.spring4; import org.springframework.beans.factory.annotation.autowired; import org.springframework.context.applic...
Read more