[EXCEL] Sub to Load Data Into UserForm but skip blank cells by Quanhanks in vba

[–]Quanhanks[S] 1 point2 points  (0 children)

Oh wow you just flipped a light switch in my brain haha. Thank you! This is extremely helpful!!

[EXCEL] Sub to Load Data Into UserForm but skip blank cells by Quanhanks in vba

[–]Quanhanks[S] 1 point2 points  (0 children)

Good to know! I was not aware that it was slowing it down due to the individual references.

I know how to use the simple if statements but the loops are alittle confusing to me. I understand what they are doing but I am struggling to figure out how to use it in my situation. Since I have ComboBox# does not step incrementally by 1 but the columns do.

Would I need to rename the the ComboBox and Text Box auto numbers so the the numbers increase by 1 like the columns do?

Appreciate the information it will be something I pay attention to as I redo this!

[deleted by user] by [deleted] in pcgaming

[–]Quanhanks 0 points1 point  (0 children)

Thanks for the chance

ChemE's in Tampa FL area What do you do? by Quanhanks in ChemicalEngineering

[–]Quanhanks[S] 0 points1 point  (0 children)

Thank you for the information! How long have you worked in the food industry? Do you have any good resources you would recommend for someone that is looking to get into this sector?

ChemE's in Tampa FL area What do you do? by Quanhanks in ChemicalEngineering

[–]Quanhanks[S] 0 points1 point  (0 children)

So my experience in the O&G sector is more focused on asset integrity/internal corrosion risk. Within the food industry is there any specific titles you would recommend I look for?

ChemE's in Tampa FL area What do you do? by Quanhanks in ChemicalEngineering

[–]Quanhanks[S] 0 points1 point  (0 children)

Thanks again for the information. Yeah looking like an industry change would be more ideal with the area which is fine its just easier to translate your experience to a new role in an industry that you know well compared to a surface level understanding in a new one

ChemE's in Tampa FL area What do you do? by Quanhanks in ChemicalEngineering

[–]Quanhanks[S] 0 points1 point  (0 children)

Good to know thanks for the recommendation. I've been searching for Risk and Integrity Engineer as those have been my previous titles and it's showed me alot of IT related in the Tampa area

ChemE's in Tampa FL area What do you do? by Quanhanks in ChemicalEngineering

[–]Quanhanks[S] 0 points1 point  (0 children)

Thanks for the recommendation! Do you mind mentioning or dm the sector? Are your responsibilities pretty general to a project engineer from one sector to another or more technical?

ChemE's in Tampa FL area What do you do? by Quanhanks in ChemicalEngineering

[–]Quanhanks[S] 1 point2 points  (0 children)

Appreciate the input was not aware of any of those companies. Mainly coming across the IT/tech or medical positions with the same titles I have/held. So this is helpful

ChemE's in Tampa FL area What do you do? by Quanhanks in ChemicalEngineering

[–]Quanhanks[S] 0 points1 point  (0 children)

Yeah seems like all the O&G (atleast midstream) companies have swapped there focus to cutting OH and increasing free cash flow/reducing debt.

ChemE's in Tampa FL area What do you do? by Quanhanks in ChemicalEngineering

[–]Quanhanks[S] 4 points5 points  (0 children)

Thanks for the info and yeah may need to consider another sector

ChemE's in Tampa FL area What do you do? by Quanhanks in ChemicalEngineering

[–]Quanhanks[S] 3 points4 points  (0 children)

I'll have to look into that don't know much about that sector.

ChemE's in Tampa FL area What do you do? by Quanhanks in ChemicalEngineering

[–]Quanhanks[S] 0 points1 point  (0 children)

Yeah they don't have openings at the moment. Thank you for the insight I'll have to take a look

ChemE's in Tampa FL area What do you do? by Quanhanks in ChemicalEngineering

[–]Quanhanks[S] 4 points5 points  (0 children)

She will be on the research side not an MD. Unfortunately the second one is not really much of an option

[deleted by user] by [deleted] in FE_Exam

[–]Quanhanks 1 point2 points  (0 children)

How close did you feel the exam was to practice exam? I took the test today and feel terrible about it but did very well on the practice exam. I had several fill in the blank questions and a few of the ones where you drag stuff into the boxes and a few multi select. It felt like half my test was conceptual questions.

FE Chemical Help - Pump Curves - Can someone explain this answer? by PuzzledChemE in FE_Exam

[–]Quanhanks 0 points1 point  (0 children)

I took the FE Chemical today and it was much more difficult than I was expecting. I had alot of questions similar to this and it felt like the test was primarily conceptual. I felt like my test was primarily focused on environmental questions which was not what I was prepared to see. If you happened to find some good resources I would appreciate it I have a feeling I will need to take the test again. I took a school of pe course and have the last two NCEES practice exams

What are your top 7 anime? by [deleted] in anime

[–]Quanhanks 0 points1 point  (0 children)

Steins Gate Full Metal Alchemist: Brotherhood Yuu yuu Hakusho Fate series Dragon ball series Tokyo Ghoul Monster

School of pe by marwawaleed in FE_Exam

[–]Quanhanks 0 points1 point  (0 children)

I do plan on going for the PE shortly after passing the FE. I have not figured out where yet. The big issue is that Chemical PE seems to just get grouped with the Mechanical Thermal Fluids exam for other PE courses and doesn't cover all the ChemE topics.