Creating A Pop-up Window With Specific Cell Data

Sep 13, 2007

I'm basically creating a file where a userform comes up when you open the workbook, blocks the access to the actual workspace so that no manual entry can be done. What the userform allows you to do is add a new entry to the database (the userform has some text boxes where we type in stuff like location and name or age) after having found the next empty row in the enormous database (3.000 lines)

After having clicked the OK button in the userform and added the data to the database, I would like the userform to have a pop-up message box with specified text like:

"The number assigned to this entry is:" and then I would like to add a variable with excel using the cell in column D of the same row of the new entry. So the end result would be :

The number assigned to this entry is: 01

View 9 Replies


Open A Specific Folder View Window

Feb 4, 2009

I'm using this code below sucessfully to open a specific folder view window. What i'm looking for is a way to amend it slightly so that when the window opens the 'folder tree' on the left hand side does not show, as it always does at the moment.

View 2 Replies View Related

Window Explorer With Specific Document Type

Apr 22, 2009

I am using the Application.GetOpenFilename command to open the window explorer view. Is there a way to minimize the selection to a particular doc type .
Example all Excel (xls) work book only or All Text (.TXT) only?

View 2 Replies View Related

Creating Dropdown Which Changes Adjacent Cell Data?

May 16, 2013

I'm revamping a key inventory for my company and would like to be able to track the history of each key (name of person who it was issued to, date issued, date returned). I figure the best way to do this for the 90 keys I currently have in circulation is to create drop down lists for each key that has been used by more than one person in its history and upon selecting a given person from the drop down list of keys used more than once, the adjacent cells would populate with the corresponding data of date issued and date returned. Some keys have not been used more than once so not every key will have a drop down. Here is what my key inventory spreadsheet looks right now.

View 3 Replies View Related

Creating An Entry By Extracting Data From A Cell

Jan 10, 2007

I have been sent a spreadsheet that i need to extract the first 4 characters of the data in column C and put that data into column D.

View 9 Replies View Related

VBA Creating New Workbook With Different Name At Specific Folder

Jul 30, 2014

VB code, recorded by macro, it is working, but I need create different workbooks with different names , this one create just one specific name here is the first problem , second would be for saving in desktop folder "Ataskaitos" here another because it just for my computer , on other computer directory would not be found and third , then I deleting existing sheet in workbook from there I run the macro and copy sheet to new workbook it asking if I sure want to delete that sheet, so I don't need asking that I just need to delete it

Sheets("Ruooinys" & i).Select

[Code] .....

View 2 Replies View Related

Creating Specific List From Large Dataset?

Jan 2, 2014

We collect loan payments for 36 months from customers.

Column A lists 1000+ customers.

Column J lists the date we received payment 1 ... Column Q lists the amount we received on payment 1.

Column R lists the date we received payment 2 ... Column Y lists the amount we received on payment 2.

Column Z lists the date we received payment 3 ... Column AG lists the amount we received on payment 3.

This repeats for all 36 payments.

New customers are loaded in each month, so be aware that Column J, Column R, Column Z (and so on) have dates from 2011 and 2012 and 2013.

We'd like to create a list of all customers that have not made a payment for the current month as of a certain day (say the 12th). So this month, on January 12th, we'd like to search our data for all customers that don't have a payment listed between January 1st - January 12th.

View 14 Replies View Related

Creating Array Of Numbers With Specific Definitions?

Feb 3, 2014

Lets say I need an array of 100 numbers from zero to 100. I want a mean of 75, and SD of 12. Or the same data based on a skewness and kurtosis value. Can I do that in Excel?

I'm just generating fake datasets for my stats class to analyze.

Edit: I found that =norminv(rand(),,) will work.

View 1 Replies View Related

Assistance With Creating A Specific Macro Using VBA Code

Dec 8, 2008

I was wondering if someone could help me generate a Macro to do the following:

I have a sheet with the following characteristics.

Column A, rows 8-15 contain headers
Column A, rows 17-24 contain headers
Column A, rows 26-40 contain headers
Column B to CV, row 6 may or may not contain an "X"
Column B to CV, rows 8-15 & 17-24 & 26-40 may or may not contain the various data

I need a macro which does the following on the press of a button located somewhere on the sheet:
Generate a .TXT file in the folder C:Test with the name "Test_YYYY_MM_DD_HH_MM_SS_Full.txt" which uses the system time and date to fill in the values In the TXT file the following data should be created: ....

View 7 Replies View Related

Creating VBA Macro That Changes Specific String To A Number

Jul 7, 2012

I am having some difficulty with a pdf that I converted to an excel document because I wanted to use the data from the pdf tables in a different program I am currently working on. However, the data is in the improper format. For example, in the table it reads 2-1/8 as string and I want it to be the number value 2.125 . Likewise if the value in the table reads 5-1/4 I want it to automatically convert it to something that will be read as the number 5.25

View 4 Replies View Related

Open Window With Data From Other Sheet

Aug 12, 2009

Say im in sheet 1 at B2. Am looking to create a button so when I press it a small window opens and displays the data that is it sheet 2 (which is just 2 columns of a list of products and price.
Then I for example double click on a product and it will be added in the current cell.

View 14 Replies View Related

Creating Macro To Print Specific Worksheets In Workbook

May 15, 2014

I have an excel workbook with about 40 worksheets. I have a formula in A1 of each sheet that returns a 1 or a 0 depending on whether or not the name of the worksheet is in a list.

What I am trying to do is create a macro that will print all worksheets that have a 1 in A1.

View 2 Replies View Related

If Data From 1 Cell Matches Specific Data Of Another Cell Then OK If Not Highlight In Red

Oct 22, 2012

I have been wracking my brain around how to put this formula together.

Is it possible or it can't do more then 1 cell at a time?

Here is an example:

If F1= button request and E1= Scoring then OK (take no action) also i want to add that Folder in F and Corrupt in E would = OK

If it doesn't match to highlight the cell in red

View 8 Replies View Related

Creating A Formula: Verify If My Actual Value Falls Within A Specific Range

Jun 6, 2006

i need to make a formula for excel which will verify if my actual value falls within a specific range. for instance if my value is 0.15 and the allowed range is 0.145 to 0.155 then i want to display the number zero in the cell however if the actual number is above or below the range i want to calculate the amount of deviation from the range

View 2 Replies View Related

Activate Window Where Name Is In A Cell

Nov 28, 2007

I am trying to activate a window and the name of the window to be in a cell. lets say: Windows(file2.xls).Active

I want something like this: The name of the file is in B2 cell in tab Sheet1 in file file1.xls so the line will be like:

i do not know what function to use.

View 7 Replies View Related

Excel 2007 :: Creating Order Form - Copy Entire Row If One Cell Has Data

Dec 3, 2012

I'm trying to create a very simple order form. It's been a while since I've done this in Excel, and I couldn't find an answer when I searched. (I may be a lousy searcher, though.)

I want the user to enter a quantity in Column E of the "Common Items" worksheet, and have all the rows with quantities copied to the "Order" worksheet. (On the "Order" copy below, I just did a copy/paste to show the desired effect.)

Excel 2007

Item Number

0.9% NaCL 1000ml Bags

[Code] ....

I'm pretty sure this can be accomplished with an If/Then, but I'm lost! Optimally, they'd enter their quantities, click on the Order sheet and hit print.

View 5 Replies View Related

Changing Time Window Data To Allow Ascending Viewing?

Apr 25, 2014

I receive data for time windows on jobs. my issue is 10-11 time frames appear before 8-9 time frames when I move data into a Pivot Table. This happens because the data I receive does have "08" signifying 8 so the "1" in 10 causes the 10-11 to appear before the 8-9. Is there a formula I could use to make this change? Currently if I want to view items in sequential order I have to go into the file and add a 0 before any jobs that start at 8 or 9am

View 3 Replies View Related

Excel 2010 :: Data Analysis Installed But No Window Appearing

Dec 8, 2013

We are running Office 2010 part of Office Professional Plus 1010 (corporate install). We have added both the Analysis Toolpak and Analysis Toolpak - VBA to the add-Ins and have the button on the toolbar, however when we click on the button, we don't get the popup window allowing the user to pick the analysis tool they want to use. Have tried this on a number of PCs (we all run the same version) and it doesn't work on any of them.

What we have to do do make this toolpak work?

View 8 Replies View Related

VBA To Pop Up Window Requesting User To Locate A File And Transferring Data Over

Jun 18, 2012

Is there a way to do this?

a) run a code that will create a pop-up window with the question, "Can you show me where the CODEMAP.txt" file is?"

b) then the user will locate the file in a pop-up window and be able to click/select the file and there are "ok" and "cancel" buttons.

c) once the "codemap.txt" file is selected, the vba code will automatically change this file to "codemap.csv" so that it will open in excel (temporarily). This file can be placed anyway, even on the desktop because it won't be needed later. This is only temporary.

d) Then on the "codemap.csv" file, everything from sheet 1, cell b1 to cell b700 are copied and pasted to sheet two of this macro

The codemap.csv file can then be deleted

View 2 Replies View Related

Copy Data From Cell Only If Previous Cell Has Specific Text In It?

Mar 7, 2014

I'm trying to copy data from one excel sheet to another excel sheet. However, the data to be copied is dependent on the 'client name'.

To explain this further, in the first list I have a detailed report on our clients and the services provided to every employee of that company/client.

However, the sheet two only needs the names of the employees that belong to a specific client.

This can be done manually by setting a fliter on the name of the client/company, but I need to be automated. To ensure only that specific company/client company's employee name is copied.

View 2 Replies View Related

Make A Cell The Top Left One In The Active Window

Feb 7, 2007

I'm trying find a way in VBA to make a particular cell the top left one in the active window.

View 9 Replies View Related

Active Cell Location In Window After Hyperlink

Dec 14, 2008

I have a worksheet with frozen panes (Row and Column). I have hyperlinks that jump to the this worksheet. Is there anyway to have the window position itself so the active cell is in the upper left corner of my frozen panes?

View 9 Replies View Related

Find Specific Data In A Cell And Move It To Another Cell

Dec 12, 2012

I want to extract the following details into another collumn (bold ) from data in column B1 into C1. The information i want begins with 3 digits with a '/' then other digits follow.

M / AS308 - :308/65588 POUN
S33 / 33 - :133/01504 TR
NI101 - :101/915635 T
N101 - :101/915635

View 4 Replies View Related

How To Get Data From A Cell Given A Specific Criteria

Jun 19, 2007

I have a big data sheet. I have approximately 2170 rows and 50 columns. In some rows I have a series of consecutive zeros. I need to build a formula that gives me the date ( located in row3) right before the first zero in the series of consecutive 12 zeros.

For instance in row 1340 I have a series of 12 consecutive zeros. The first zero happens in column AC, therefore I need the formula to retrieve cell AD3. however every rows has zeros located in different cells therefore I need a general formula.

View 9 Replies View Related

Delete Row If Cell Contains Specific Data

Jul 27, 2007

I need a quick macro that will search column D for the words "balance forward" then delete the entire row. The macro needs to loop through many rows and it contain more than one "balance forward" reference.

View 9 Replies View Related

Time In Specific Cell When A1 Contains Data

Mar 24, 2009

A vehicle has been assigned to collection, time of entry appears in Load cell coresponding with vehicle eg.e vehicle 1 'A1' = load 1 'B1'. I can get the exact time to appear in the cell currently but when I try to assign a second truck, the load 2 'B2' cell AND the load 1 'B1'. Im sure that there is an easy way to do this but i just cant figure it out. Can someone please help me out. Can i disable the cell that is updating?

View 9 Replies View Related

Using VBA To Replace Data In A Specific Cell

Apr 26, 2006

I have a spreadsheet, where I am measuring dimensions for a cpk test. My question is, can I use vba to format the calculated cpk cell so that if it falls below a certain value it replaces that value with whatever I have specified in vba? Was wondering is this is possible.

View 5 Replies View Related

Copying Row To Other Worksheet If Cell Has Specific Data

Jan 4, 2010

I have an Excel 2003 spreadsheet with multiple sheets - one main one with all data and others which have only the data that falls into certain criteria. I'm wondering if there's a way to enter the information on the main sheet and have it automatically populate the correct "sub-worksheet" depending on what is entered in a specific column.

I'm not describing this well but I've attached a sample of what I mean.

View 6 Replies View Related

Entering Data In 1st Blank Cell In Specific Row

Mar 5, 2014

I have created a form where a date and remark is added every few days. I am using Phone Number as the base of VLookup. I want a code so that the date and remark which is entered in a Text Box, is stored in the first available blank cell pertaining to that employee. I want the first date and remark to be under "Date 1" and "Remark 1".

Thereafter, if another remark is subsequently added for that employee, the form would ask to enter his phone number to identify which employee the remark pertains to. Then the Text Box where remark is entered should be stored under "Remark 1" if there has been no remark before, "Remark 2" if "Remark 1" already exists, "Remark 3" if "Remark 2" already exists and so on.

I do not want to enter it in a new row. I want to enter the remark in the next blank cell of the row which matches the employee Phone Number.


View 5 Replies View Related

Formula To Extract Specific Data In Cell?

Dec 2, 2011

I have data in several cells, and I want to extract only the information in the cell up to a /. For example "joesmith/shipping" I would like to have only joesmith in the cell next to it.

View 2 Replies View Related

Copyrights 2005-15, All rights reserved