hi professional
I need finding solution to my problem .I designed simple userform to test how works to implement for my project , but I'm surprised it doesn't work in column C
it should update after fill in textbox3 . it just work for column A,B when changes .
by the way I issued this post in this forum https://www.mrexcel.com/board/thread...t-all.1184312/HTML Code:
any help to find where is the problem ,please?
Last edited by KalilMe; 10-12-2021 at 05:40 AM.
Your Combobox1_change event kicks in when writing to worksheet so your TB's are set back to default, making any changes undone.
In a Userform there's no EnableEvents property so we create our own one.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
excellent ! finally it works, but why this case occures with me . I have ever used this code in many cases and I don't face like this problem . why happens this now ?
KalilMe,
Just change Initialize event to
Please Login or Register to view this content.
@jindon perfect ! that's work excellently . just question about thisactually I forgot put it , and even that works. does this missed line cause problem ?HTML Code:
If you manually delete RowSource from the property window, it is not needed.
then I should depends on it instead of do that manually .
this problem caused me headache for two days .
thanks very much for solve my problem.
have a good day !
@bakerman thanks for your solution, but I see the best answer is for mr.jindon
solve all your headaches and stop using rowsource - if you do not believe me then read-up on all its downfalls in the link below.
also there is no need for search routines interacting with the sheet - in your case there is a direct link between the combobox.listindex and the sheet row.
less interaction with the sheet using data placed in memory = speed, using structured tables also enhances data referencing.
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks