Dear Chandoo,
I got this VBA code from internet to generate skyline chart based on data source in "System" sheet.
To generate the skyline, we need to go to "Skyline" sheet and press "Generate Skyline" button. And the code works fine.
>>> Moved this thread from Ask an Excel Question to VBA...
Hi,
I have 3 textboxes in number format. In texbox1 value = 11, textbox2 value = 5 and textbox 3 value = 11.
And I want to count how many number of 11 in a textbox4, every time the value in textbox1 is change or update.
Private Sub TextBox1_AfterUpdate()
On Error Resume Next...
Dear Chandoo,
I have to add both vertical and horizontal scrollbars in a userform, so far I have this code below for horizontal scrollbars only. The question 1, how to make a vertical scrollbar in the same userform?
Private Sub UserForm_Activate()
With Me
.ScrollBars =...
I changed the code into this, and running well.
TextBox8.Value = Evaluate("=Lookup(2,1/(Data!F4:F23=""" & Me.ComboBox1.Value & """),Data!O4:O23)")
Thanks so much for your help. I really appreciate it.
Chandoo is the best !!!
Hello,
I want to extract the last driving kilometer of a vehicle ID, let's say 27001 thru a ComboBox1.
The database is store in sheets "Data", and the number of vehicle ID is in column F while the driving kilometer is in column O.
So, when I change the vehicle ID in ComboBox1 then it will...