Recent content by kabushnell

Thanks, that's what I needed. When I do the Text to Columns I just format that column as text and it comes through fine.

I have a .txt file that I am opening with Excel so I can parse some data from the file and import into another program. I have one column of data that I cannot get to format properly. Most of the cells contain numbers which need to be formated to nine digits. I can format those ok using the...

Please ignore this post. By using formFields result versus value I was able to make the code work.

I have created a several page form with protected form fields. Upon entry of several fields a form will open for user entry. My problem is that I had set the code to unprotect the document and input the data into the document and then reprotect. The problem is, once you unprotect and then...

Please ignore this post. I was able to get my code to work using the Auto Filter and the recorder. Thanks

I am working a macro that will look in Column F for either a T or Z. If column F is either T/Z and column G is prior to 1/1/2005, I would like the entire row to be deleted. I am having a little trouble getting the code to do this.

Just what I needed. Thanks for your help.

Thanks again for your help. One more quick question on this. There are a variety of combinations of the three radio buttons and checkboxes. For example a user has to select one radio button and up to six checkboxes and with each checkbox certain text is added to the same cell. I was going to...

Thanks, just what I needed.

I think this is fairly simple and I can't quite get it. I have a form that opens in Excel when a macro is ran. When the form opens, the user must select one of three radio buttons and may choose up to five checkboxes. When the user chooses one of the radio buttons and a combination of...

I have code that creates a user form with a Combo Box. I would like this form to open after a macro runs with some worksheet formatting. This will allow a user to select from the combo list and input a value into cell D1. I am not sure how to get the code to open the form and when a choice is...

Works great. Thanks

I am working on a macro and almost finished except I can't make one part work. I want to copy the value in cell B1 and copy to all rows in column B. I am trying to have it paste but the problem is the number of rows changes. I have used a code similar to the one below before with sucess but I...

I have a macro that I would like to copy the data in column B down to the last record in column C. The number of rows changes daily. I can get it to copy to a specific number of rows but I am not quite sure how to get it to look at the number of rows in C and only copy B to that number of rows.

I ran the code above and on my test files it deletes all but one row that begins with "f". Any thoughts as to why? Also, anyone have any other ideas on how I can combine those amounts as shown above?