I have two seperate data sets that are recorded into basic worksheets on excel. However, I need the text in the first row of cells changed to a user defined name, and I need a description or units for that name in the cell below it. It would be helpful if the user didn't have to change this data in the code itself each time different data is recorded. For ex: Have a list where the user inputs what they want to change in an excel worksheet, then take that to change the text in another worksheet. Maybe a ActiveX control in a seperate worksheet would work. Any thoughts
User-defined Excel Input Thoughts?
Well all, I've got a problem with an excel macro. I have two seperate data sets that are recorded into basic worksheets on excel. However, I need the text in the first row of cells changed to a user defined name, and I need a description or units for that name in the cell below it. It would be helpful if the user didn't have to change this data in the code itself each time different data is recorded. For ex: Have a list where the user inputs what they want to change in an excel worksheet, then take that to change the text in another worksheet. Maybe a ActiveX control in a seperate worksheet would work. Any thoughts
I have two seperate data sets that are recorded into basic worksheets on excel. However, I need the text in the first row of cells changed to a user defined name, and I need a description or units for that name in the cell below it. It would be helpful if the user didn't have to change this data in the code itself each time different data is recorded. For ex: Have a list where the user inputs what they want to change in an excel worksheet, then take that to change the text in another worksheet. Maybe a ActiveX control in a seperate worksheet would work. Any thoughts
User-defined Excel Input Thoughts?
GrahamWilliams