Posts by zoog25

    Hello all,

    I'm having problems with the following code:

    For whatever reason, it isn't liking the red section of my code. I'm trying to select columns W through Y of row "lrow" and adding color to those cells. I'm not sure if i'm just not coding right but all examples i have seen point to this method. Please let me know if there is a different method or if i'm just missing something to make my code work. Thank you.

    Hello All,

    I need help with coding for a worksheet change event.

    The situation is i have two sheets. "Tract Parcels" and "NOC".
    In "Tract Parcels" i have columns C, D, E, G, H, I with information. When all each column is filled, it would first check to see if B, D, E, G, H, & I information is located in columns C, E, D, F, G, I respectively. It it does then a message box appears saying "Project already appears in NOC Tracker.", otherwise the program will find the first empty row and copy and paste the information into that row. Don't know if this is too complicated, so please let me know if there needs to be more clarity.

    Also, if say this worksheet change event runs and starts filling in "NOC". I have a change event in "NOC", could the change event in "NOC" be disabled when the first event runs.

    Hello All,

    It's been a long time since i have really done any coding and i'm having some issues. Currently i'm trying to write an worksheet event change macro. The situation is this, the worksheet has several columns, The key columns here is A and F. Now what i'm trying to do is that after a person inputs a value into column F and either clicks away, tabs over, or hits enter, it will check the corresponding column A cell as the entered information in F was. If A is blank then it pops up a question box. If A isn't blank then nothing happens.

    Now I have been researching and trying my best to make it so the question only appears after a value is entered in to "F" and then it doesn't appear again, unless say the information from "F" is deleted. So basically if "F" is blank, it runs a question to fill in "A". Then as long as the value of "F" isn't deleted, then question doesn't come up again, unless the value of "F" is deleted and "F" is now blank.. Now note the value in "F" is going to always be a string of numbers like "6730". 4 to 5 digits in length.

    Re: Converting a text string into a number string

    Hello Krishnakumar

    I tried adding your code to my project and I get an overflow error.

    Here is how I incorporated it:

    projnum = Left(jobarray(3), 9)
    projindex = Format(Val(Replace(projnum, "-", vbNullString))*100+1, "###,###,###")

    Don't know why it is giving the overflow error.

    Hello all,

    Here is the situation, I am working on a macro that extras folder names that are located in a directory. I've been able to isolate a unique text string that looks like this "987-65-43". Now I need to be able to convert that text into a single number with two additional digits. So macro would work to convert the text string "987-65-43" to the number 987,654,301. So in a sense it would remove the dashes and the number would then be multiplied by 100 to move the new number string over two spaces and then add 1 to the number in order to get 987,654,301. Please help me figure out this process.

    Please note that the text string will always be in the format "###-##-##" and the new number would be put into a variable called proindex.

    Thank you for any assistance you can provide.

    Hello All,

    Here is the situation and I'm not sure if this is possible. I'm working on a macro connected to a command button. Now when a sure clicks on the button. One of those Windows directory windows appears and prompts the user to select a folder. The folder path is then extracted and separated outs. The folder path will typically be in this format.

    J:\Projects\### Text\###-##-## Text\Doc

    I need the information located in "\### Text" and "\###-##-## Text".

    Anyways if this is possible please let me know. I'll continue to do research to see if this is possible.

    Hello all,

    I'm dealing with coding that creates a hyperlink based on if you enter information into a column. The problem I'm having is that if any changes that touches the column triggers the coding. I was wondering if it is possible to modify the code only if a physical entry is made in the column that the code is initiated.

    Anyways here is the code I'm using:

    Also if there is a better way of doing it, please let me know.

    Re: userform combobox populated from two columns of a table

    Hey all thanks for the help.

    I was able to make a few adjustments and got the code userform to work how I wanted it too. This saved me a lot for the ultimate project I'm working on. I'm including the final code below:

    Re: userform combobox populated from two columns of a table

    Thanks royUK for the information. I will test your code once I get the first one from Adrian B's code.

    Now the code for the combo box works except instead of show two columns, all I get is one column with first information and then second information below it. I'm attaching a sample of the workbook to make things easier. Please see what you guys can do to fix it.

    Re: userform combobox populated from two columns of a table

    Column 1 has a project code like "077-09", Column 6 has the project name. Now each sheet in the workbook is title by the job number so in this case "077-09". So it takes the number sequence of ###-## and then opens that worksheet.

    Now I tried Adrian code and it works but instead of shows it like "077-09 Project Name" it goes

    Project Name

    so now I just need to have first the columns to combine in the list so it appears at 077-09 Project Name and then once selected the userform has a button that would essentially open the worksheet (Show, Unhide, Select, how ever that is called) and the user would see the project sheet.

    Hello all,

    Here is my situation:

    I have a userform called ufExisting. On the userform i have a combobox called cmbExisting.

    Now here is what i'm trying to do.

    On a sheet called "Client Records" i turned it into a table called [ClientRec].

    Now i want to populate the combobox with columns tables 1 and 6.

    The reason i'm doing this is cause the combobox selection will open a sheet in the workbook that is based on the information from the column 1 table.

    Thank you for any assistance that you can provide.

    Re: Coding Assistance With UserForm Using a Checkbox

    Hey cytop. Thanks for the assistance. It works great. I made the change to the code like you suggested and now it works great. Here is the final code.

    Thanks for the assistance.