LinkBack URL
About LinkBacks
Hi, I've put some code together to achieve:
TextBox7 - Combobox19 = TextBox9
However, I think I've cocked this up! Help
Please Login or Register to view this content.
Hi, I've put some code together to achieve:
TextBox7 - Combobox19 = TextBox9
However, I think I've cocked this up! Help
Please Login or Register to view this content.
You have too many right brackets - delete the ones in red:
But you don't need the variable, in this case - you could simplify to just:Please Login or Register to view this content.
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
It doesn't seem to be working. Is it because they're text boxes as opposed to Combo?
That depends what you mean by "not working".Originally Posted by bralew
Attach a workbook....
(and please, consider my earlier advice about renaming your controls to something more meaningful!)
Why use the Change-event of your target TextBox ? use the Change-event from either TextBox7 or Combobox19.
Don't forget to put in a check to see that both source controls are filled.
@ Olly
As I see it that's a bad idea because you prohibit yourself that way in using easy to program loops to fill your controls. But that of course is my personal opinion .consider my earlier advice about renaming your controls to something more meaningful
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.
An interesting debate - for another thread@ Olly
As I see it that's a bad idea because you prohibit yourself that way in using easy to program loops to fill your controls. But that of course is my personal opinion .
Here's the workbook chaps
choose 54 square in the first user form and you'll be into the main userform.
Try putting the code in the TextBox7_Change event:
Please Login or Register to view this content.
Ahh Thanks Ol, didnt see that lurkinyg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks