Using Spin Buttons in Excel
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Aamir
Hello, thanks for video and sharing your knowledge / expertise.
I am not an vba expert but know using it to make my daily routine tasks easier.
I have a situation where using one single spinbutton i want to change values in range A1-A5
I am trying to change spinbutton's linkedcell value by using activecell.address but getting error on run time.
Could you please guide / help how to do it?
reply
Hello, thanks for video and sharing your knowledge / expertise.
I am not an vba expert but know using it to make my daily routine tasks easier.
I have a situation where using one single spinbutton i want to change values in range A1-A5
I am trying to change spinbutton's linkedcell value by using activecell.address but getting error on run time.
Could you please guide / help how to do it?
reply
Darlie
Good Day Sir, can you take the average of text for example.
A1 TEXT1
A2 TEXT1
A3 TEXT1
A4 TEXT2
A5 AVERAGE of A1,A2,A3,A4
But if use this formula =CONCATENATE(A1,A2,A3,A4) the result i get for A5 is this (TEXT1TEXT1TEXT1TEXT2),
i just want to show is the a average which is IN A5 TEXT1.
reply
Good Day Sir, can you take the average of text for example.
A1 TEXT1
A2 TEXT1
A3 TEXT1
A4 TEXT2
A5 AVERAGE of A1,A2,A3,A4
But if use this formula =CONCATENATE(A1,A2,A3,A4) the result i get for A5 is this (TEXT1TEXT1TEXT1TEXT2),
i just want to show is the a average which is IN A5 TEXT1.
reply
education
I don't use Excel but your video inspired me to research and figure out how to do this on LibreOffice Calc. It took a while, because some of the controls are different, but I did it! Thank you for teaching me something I didn't even know I wanted or needed!!
reply
I don't use Excel but your video inspired me to research and figure out how to do this on LibreOffice Calc. It took a while, because some of the controls are different, but I did it! Thank you for teaching me something I didn't even know I wanted or needed!!
reply
Vikas
How to use 30+2 as number.
When I write 30+2 in excel it is as a text than how to use it as a number in excel.
Ex.
30+2
50+5
34+1
I want to use it as a number in excel and want to perform sum, multiple function with this.
reply
How to use 30+2 as number.
When I write 30+2 in excel it is as a text than how to use it as a number in excel.
Ex.
30+2
50+5
34+1
I want to use it as a number in excel and want to perform sum, multiple function with this.
reply
The
Great video. Is there a way I can create multiple Spin Buttons without individually having to assign a cell link to each one? I can't seem to drag it like I can with formulas to have it assign to a corresponding cell. Is there a way?
reply
Great video. Is there a way I can create multiple Spin Buttons without individually having to assign a cell link to each one? I can't seem to drag it like I can with formulas to have it assign to a corresponding cell. Is there a way?
reply
WakeUpAmerica
Great video! Thanks! Using this feature for an inventory counter, is there a trick to allow negative inventory counts in the event our count is off so we know that something is missing?
Thanks again for sharing.
reply
Great video! Thanks! Using this feature for an inventory counter, is there a trick to allow negative inventory counts in the event our count is off so we know that something is missing?
Thanks again for sharing.
reply
Cool
thank you for this video ...its very useful ..can you plz show me how to convert a pdf to word ..i have MS word 2016 and when i try to open my pdf file in word i cant .plz help me !!
reply
thank you for this video ...its very useful ..can you plz show me how to convert a pdf to word ..i have MS word 2016 and when i try to open my pdf file in word i cant .plz help me !!
reply
Adham
The best teacher I ever had online. I like it when you said 'That's too bad isn't true' for the total earnings' hahaha XD.
Stay blessed and healthy, teacher.
reply
The best teacher I ever had online. I like it when you said 'That's too bad isn't true' for the total earnings' hahaha XD.
Stay blessed and healthy, teacher.
reply
Emerald
Love your videos! So helpful for students like me who are not tech-savvy! I would love to see a video for tips and tricks to maximize OneNote for students :)
reply
Love your videos! So helpful for students like me who are not tech-savvy! I would love to see a video for tips and tricks to maximize OneNote for students :)
reply
Stephen
Hi Technology for Teachers & Students, I'd love to chat with you about a business opportunity. Do you have an email address that I can contact you at?
reply
Hi Technology for Teachers & Students, I'd love to chat with you about a business opportunity. Do you have an email address that I can contact you at?
reply
Add a review, comment
Other channel videos
