Search results for query: *

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

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

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 am looking to take a cell value and return it to a userform. I do not need to edit the value within the form. Just need to return the value, and maintain formating. At the present time I have the cell value being returned by using making the controlSource of a userform textbox to =...

I am trying to have the inputs from a form, populate a database on a seperate sheet of the same workbook. I need the database to start at a specific cell. I have a heading on the top and the first two columns have formulas. I have been playing around with my code and it seems that the...

Hello, I have managed to screw up my XP Pro's windows explorer default function. So when I click on a folder within windows explorer it does a "Search" and not the default "Open" This is extremely annoying. I was trying to get a print out of all the files within a folder, so I found and...

I am trying to get a form module to call a "public sub" module, and keep getting a "Compile Error: Sub or Function not defined" Error, Any Ideas out there? my looks like: private sub cmdCreate_Click() ' This is the command for creating letter in the form module. 'lots of commands here 'ends...

I know this has been asked many times, but I am missing something. I can close my file, but would like to close the window application it created as well. I seem to be stuck, can anyone help me out? Here is what I've come up with, ' close form Unload Send_to_information 'close...