Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bsurfn99

    How to Copy a range X times, and then copy/paste a variable Y times, and index?

    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...
  2. bsurfn99

    How to Copy a range X times, and then copy/paste a variable Y times, and index?

    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...
  3. bsurfn99

    How to Copy a range X times, and then copy/paste a variable Y times, and index?

    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...
  4. bsurfn99

    How to Copy a range X times, and then copy/paste a variable Y times, and index?

    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...
  5. bsurfn99

    Userform Textbox linked to Cell value.

    Perfect. Thanks for explaining the error as well.
  6. bsurfn99

    Userform Textbox linked to Cell value.

    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...
  7. bsurfn99

    how to extract most recent data from database

    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...
  8. bsurfn99

    how to extract most recent data from database

    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...
  9. bsurfn99

    how to extract most recent data from database

    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...
  10. bsurfn99

    How to fill cell values from textbox vba form

    Just wanted to say thanks! That worked great, and it's so much simpler. thanks again. -bsurfn99
  11. bsurfn99

    How to fill cell values from textbox vba form

    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...
  12. bsurfn99

    How can I limit use to only local network?

    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...
  13. bsurfn99

    How can I limit use to only local network?

    I forgot to ask about your comment on "you need a reference to "Microsoft Scrtipting Runtime." What do I need to do to for this? BsurfN99
  14. bsurfn99

    How can I limit use to only local network?

    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...
  15. bsurfn99

    How can I limit use to only local network?

    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...
  16. bsurfn99

    How to place a cell value into a userform?

    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...
  17. bsurfn99

    How to place a cell value into a userform?

    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
  18. bsurfn99

    How to place a cell value into a userform?

    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...
  19. bsurfn99

    How to place a cell value into a userform?

    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...

Part and Inventory Search

Back
Top