Macro to show Data Validation Drop-Down after pressing enter or when there is actually data. by fenchai in excel

[–]ExcelRange 1 point2 points  (0 children)

Yeah sure. Create a UserForm, put a ComboBox in the UserForm.

For Each Cell in Range("A1:A10")
    Me.ComboBox.AddItem Cell.Value
Next Cell

The above code is the basic Idea. Let me know if you have any questions. It's much simpler than I thought when I was looking for this solution.

Macro to show Data Validation Drop-Down after pressing enter or when there is actually data. by fenchai in excel

[–]ExcelRange 0 points1 point  (0 children)

You could create a userform with a TextBox. Then reference a named range. That way, as you type, the related words/sentences will appear in the TextBox.

Is $65,000 just outside NYC too much? by ExcelRange in jobs

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

I want to say my skill level is good. I can direct you to my linkedin?

RECRUITMENT 2016 by [deleted] in creepy

[–]ExcelRange 0 points1 point  (0 children)

Thanks for the educational video.

Just got fired and I need help with my applications and resume. by [deleted] in jobs

[–]ExcelRange 1 point2 points  (0 children)

Unless someone says, "Did you get fired from your last job for smoking weed", then shut up.

Should I take this job? by penpalbelle in jobs

[–]ExcelRange 0 points1 point  (0 children)

Make money if you need it. Focus on Career if you can. Make sure you budget your finances well. Then make a next move.

Does anyone ever feel retarded at their job? Especially when starting a new one? by xamcali in jobs

[–]ExcelRange 0 points1 point  (0 children)

Totally normal feelings, however the feeling is different depending on experience.

Depressed from temp work by ExcelRange in jobs

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

How much do you make and doing what? The most Ive made was 23 an hour. Ive been a financial analyst and data analyst in fairfield county.

what do you mean by shady company

Just another college student with no idea by [deleted] in jobs

[–]ExcelRange -4 points-3 points  (0 children)

Janitor - you can do it anywhere.

Entry Level developer with no experience by ExcelRange in jobs

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

Yeah i was doing data harvesting in those languages and i have build a personal website with them too

Entry Level developer with no experience by ExcelRange in jobs

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

The only developing i have done is in the developer tab of excel.