Hi, i have a userform where users can log in and enter data. In the "Batch Manager" tab, there is a combobox 2. Users select from this available values and the accompanying data from the worksheet should populate into Listbox4. What is wrong is that it only works if the cell value is alphanumeric, meaning it works for B20171222 but not the rest. The combobox is supposed to populate unique data from column B, but i cant get it to work properly too. Can someone please help to see what is wrong?
Last edited by bqheng; 08-16-2017 at 04:27 AM.
I think the issue may be in this line of code:
see if changing that to:
Please Login or Register to view this content.
makes a difference.Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
hi alan, nope didnt work.
Last thought on this.
try dropping the .value
Value from then control is a String and you are comparing Numeric value to String, so not match.
1) Add one Variant type variable
2) Add 2 linesPlease Login or Register to view this content.
3) ChangePlease Login or Register to view this content.
toPlease Login or Register to view this content.
Please Login or Register to view this content.
Hi jindon, that did the trick! can you please help me with the other problem i mentioned earlier? how do i populate combobox2 with unique values from column B?
how do i populate combobox2 with unique values from column B?Please Login or Register to view this content.
Thank you so much jindon! and thank you alan for helping too
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks