Profile

Cover photo
Jerrold Ware-Ehlers
25,998 views
AboutPosts

Stream

Jerrold Ware-Ehlers

commented on a channel on YouTube.
Shared publicly  - 
 
Cynthia
I am working on a program I call Stucco Pal. It calculates all the different systems that we offer. I am using a userform with Multipage. I have all the calculations in and it is working good. I do have one page set up just for data entry onto a worksheet and I am able to enter that data. I have recently put a Listbox  so that you can go in select the data on the worksheet. That I have accomplished, however I am wanting to be able to select the data have it appear back in the textboxes and comboboxes where I originally entered the data to update it if necessary. The listbox , texboxes, & comboboxes are all on the same page in the userform.
1
Cynthia Brown's profile photoJerrold Ware-Ehlers's profile photo
2 comments
 
Thank you so much for getting back to me so quick I will look at the page
Add a comment...

Jerrold Ware-Ehlers

commented on a video on YouTube.
Shared publicly  - 
 
I have a question...I have a combobox in userform I also have a textbox that I want to show the following formula if the item is selected in the combobox
if combobox1= "Primus" then TextBox5 = Round(1 + Squarefootage / 230, 0)
if combobox1= "Primus DM" then TextBox5 = Round(1 + Squarefootage / 110, 0)
if combobox1= "EPS" then TextBox5 = Round(1 + Squarefootage / 144, 0)
if combobox1= "Standard Mesh" then TextBox5 = Round(1 + Squarefootage / 600, 0)
currently this will not work..I need some guidance please!!!
 Can you please help me?
1
ExcelVbaIsFun's profile photoJerrold Ware-Ehlers's profile photo
4 comments
 
kewl!!
Add a comment...

Jerrold Ware-Ehlers

Shared publicly  - 
 
Baby Jacks new ball....
2
Jerrold Ware-Ehlers's profile photoSee-ming Lee's profile photo
9 comments
 
Haha. The donkey had the one, I hope, not the dog ;)
Add a comment...

Jerrold Ware-Ehlers

Shared publicly  - 
1
Add a comment...

Jerrold Ware-Ehlers

commented on a video on YouTube.
Shared publicly  - 
 
I used your code and it worked great!!! Thank you!  can you help me...I want to populate the user form with that data and edit it, and clear user form and show user form.
1
Trevor Easton's profile photo
 
Hi Jerrold,
The staff database.Staff Registration project expands on this and does what you want.
Thanks for the feedback.
My best wishes
Trev
Add a comment...

Jerrold Ware-Ehlers

commented on a channel on YouTube.
Shared publicly  - 
 
WiseOwl...I need your help please
I am working on a workbook that will help a lot of my comrades in there daily work environment. I call it Stucco Pal. It calculates all the product that you need for each system (or will do that when I am done...LOL) I am at a point that I can't figure out how to create the right formula for part of it to work.
I have set up several textboxes that calculate the product needed per the squarefootage that is entered. However on some of the products you have a choice of different items and I need to be able to select the correct item then have the textbox calculate the quantity of the product needed by what is selected in the combobox... If you have an email I could send you a copy of my worksheet that would be nice...my email is Jerrold@acgci.com

Your friend in Florida
1
Add a comment...

Jerrold Ware-Ehlers

Shared publicly  - 
 
LOL!
1
1
Przemysław Pytel's profile photo
 
sweet :)
Add a comment...

Jerrold Ware-Ehlers

Shared publicly  - 
 
Good Morning...TGIF
1
Add a comment...
Basic Information
Gender
Male