vbl

Hello all, I have a userform with a name dropdown and a date text box. How do I write a macro to activate a sheet based on that information? I have a cell on each sheet equal to the name of the sheet. I.E. B1="John 07-15" which the sheet is named as well. If a user enters John and 7/17/15 I...

Hi guys and ladies, I have yet another question that I hope somebody here knows the answer to. I have the following situation: A single Excel sheet with a total of 44 columns that contain content. The content is devided as follows: A2 has text => B2 has LEN function to count the characters...

Hello- I have searched the forum, but have not been able to find this exact question. Found a bunch of related questions, but wasn't talented enough to translate them to solve my problem. =) I would like to conditionally autohide columns in response to a changes in the value of a single...

Ok i am a new to Excel and VBL. So far what i have is a user form that the user will input text in. data entered are Last Name(text box), First Name (text box) , Date (text box) , Male(option box) and Female (option box). What i am trying to do is have all the info for a male be entered onto...

Trying to pull data out of a spreadsheet and I am getting this error "Doesn't support this property or method" for line F1=ActiveWorkbook.ActiveSheet. I've used something very similar to this before. Any idea what I am missing? How can I define the array for F1? Is it needed? Sub...