Skip, Thanks for providing the file. I actually did rename the structured tables correctly. What I did NOT do correctly is rename my Table headers, to "ID Codes" and "Category" Once that was done everything worked great. Thank you for your insight and help! This is a powerful way to do...
Skip, yes that is what I attempted. Sorry, when I rename the tables it only selects the table contents and it doesn't seem to reference them.
Andy, if you are game to showing how you connect start locations. I am attempting to take info from "inputs" @C12 and then copy and transpose them to...
Skip, Andy, Zelgar,
All great responses. Thank you! I missed the email notifications due to a spam filter, but have since been playing around with the code and trying to make things work.
As a general note, the location is
Skip, - Your code appears to be so elegant I want to make it work...
I have been stumped by a problem, that I have created a mess of VB examples that nothing works and nothing is coming to mind, so I'm trying a clean slate to hopefully get some fresh perspective on my problem.
Visually here is what I want to happen in Excel. I have 2 variable length tables that...
I am looking to have a userform textbox value linked to a cell. I would like to act as default, being able to be changed by the user should they desire. I will then take the data and put it to a database.
There are a lot of threads on this, but I have been unsuccessful in applying them to...
skip,
I gave your code a spin, and I may not be putting it in it's correct context. your code counts the number of rows, but how can I use this info to extract the last 5 filled rows of information? If I change your code to .select, instead of .count, it captures the whole table which would...
Thanks for your interest in helping.
I do not have a date stamp, but do have an index number in column 2. I am looking for the "last 5 entries" rather than saying "find everything within a certain time period."
I was planning on just modifying a loop process to find the last 5 filled rows...
I have a excel database that consists of text, numbers, and columns that are formula results. It grows by adding information on the following row. I would like to be able to extract the most recent information from it, let's say the last 5 rows and then paste that information into a different...
I have a script that takes textbox entries from a vbaform and finds the first blank row and places the txtbox value in the cell.
What I need to do it place all form values into the same row as the first blank column.
Here is a visual example of what I need database to do.
column-> A | B | C...
Gerry Thanks,
It works like a charm. As for permissions vs. VB, I realize that VB is limited security, the file is a low consequence, so I think the VB solution is fine. I understand that permissions would be the ideal solution, but I don't have admin access.
Thanks again for your help...
Thanks Fumei! That was exactly what I was thinking of.
As far as Permissions vs. macros. I'm not familiar with how to assign permissions to an individual file in windows. I'm trying to prevent unauthorized use offsite.
Could I assign Permissions in a way that would address my concerns...
I would like to limit the use of file to only a local network. Anybody have an idea how I could accomplish this? I was thinking of inserting a statement in my AutoOpen macro to look for a specific network drive. If the drive was present it would open, if not present it would close...
I'm sure the answer is within your first post. I haven't used "WITH statements" much though, and must be missing something inorder to get it to work.
I did get the label to work from the cell. So thanks for pointing me in the right direction.
Here is what I ended up with.
Dim...
Problem = how to apply a cell value to a LABEL within a userform.
If that will allow me to maintain my cell formating. That would be perfect.
Thanks
-bsurfn99
I need to display the current value, and then edit it. I wanted to display the value seperatly from where I enter the new value.
This is what I currently have.
Private Sub cmd_ok_Click()
'for return cell value
Dim cellvalue As String
'set textbox value to variable name...
Thanks for the quick response.
I suppose I should put things into context a little.
I have a userform that I needs to contain the following:
1. Return cell value with formating (showing $). (can be non-editable)
2. Textbox that would allow user to modify the cell value, once submitted...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.