I need to have a cell validated to make sure the cell value is in the format of ##/##. The value should actually be the date in MM/YY format.
Any help would be appreciated.
How do I code a macro to prompt a user to enter a date, then that date be appended to the beginning of several filenames? The process consolidates data from other spreadsheets, and the two ma...
Wish to change data from ALL CAPS to first character CAP and remaining characters lower case. Can I do this without re-typing all data?
As an 'example only', in the attached spreadsheet, the columns E through AB need to collapse to the greatest extent possible around whatever value might be inside the range of E29:AB70. Using...
I have two textboxes on a form, with the following code
(Initial rate)
Private Sub TextBox2_Exit(ByVal Cancel As MSForms.ReturnBoolean)
TextBox2.Text = Format(Val(Replace(TextBox2.Text, "...
I would like some assistance in setting up a form in an excel spreadsheet. The form has 5 columns. Column 1 has a drop down list and depending on what is selected, the other columns automati...
hi,
I have 6G of data, looks like this: (no files have the same name even they are in different folder)
folder1
file1.tif
file2.tif
folder2
file3.tif
file4.tif
file5.t...
On a form in Access, in the double click event of txtEmailID I have:
OpenEmail Me!txtEmailID
With a double click, it opens the email in question.
With each additional double-cl...
I'm trying to get a count based on col A:A (item#) and AB:AB (manager)
I'm NOW convinced that COUNTIF won't do it.
I'd appreciate some help
Thanks
I have received help in compiling the code Sub ffind().
At:
sSheet = InputBox("Please enter sheet name")
would it be possible to be presented with a dropdown list of all worksheets so tha...
Hi everyone,
I created a program for our company in Excel 2003 using several VB macros that worked great. We are now converting over to Vista / Office 2007 and all of the sudden the program...
I have a table of survey information (attached) that I have been tasked get information out of. The format of the spreadsheet is that each person received a participant ID. Each row shows the...
I have an excel file I need to import to our system. Some of the present entries are 11 digits and some are 12. I need them to be 12 characters long all across the file, if its 11, I need to p...
I need some assistance in creating a Macro in an Excel Spreadsheet which will save the file to a specific location each time it is opened. I would like the Macro to include an automatic overw...
Could someone please assist with writing up an if statement
if there are no values or zero values in all cells within the following range A1 to A10 put in nothing, other wise put in the tot...
Hi
Ihave a module containing hundreds of lines of VBA code.
Is there a way to insert a ' to make all lines inactive or perhaps a method
of deactivating the code in just that module so th...
Using Excel VBA, "Application.Dialogs(xlDialogInsertPicture).Show" shows the dialog box to insert a picture on my sheet. I know there is an argument named "file_name" applying to "xlDialogInse...
Hi Experts. After working with a couple of real experts, I am closer to having the perfect spreadsheet for a task that has been a thorn in my side for awhile.
Within the attached spreadshe...
Hi everyone,
I have a workbook that does some calculations with a pivot table. I would like the copy the values from a specific range (eg. grand total) to another existing workbo...
I have part written and part recorded a set of macro's in MS Excel 2007. I have done my best to ensure backwards compatibility (as the user is running MS Excel 2000).
However when I run t...
Hi everyone,
My company currently uses an estimating program that was built in Excel using VB. I've been assigned to making some changes to the program, one of those being changing the col...
I installed the Office Web Components and published an Excel spreadsheet to an Intranet using IIS. It works fine except for one thing: the window size is not big enough to display the entire d...
I opened Microsoft Excel 2007 file today, and the font had changed in all of the workbooks to Geneva. AFter that, every excel workbook I open is opening up in Geneva. I checked under the op...
I have some pivot style data see attached file but cannot seam to produce a pivot style or meaning full graph - the graph measuers the length of errors per day
How do I upgrade the attached macro to obtain the information it uses to populate the center header from a NAME'd cell anywhere in the workbook instead of from a reference to an absolute cell ...
