Excel Programming | Forum profile

The short answer is no... -- HTH... Jim Thomlinson "LuisE" wrote: > Is there any way to replicate the MouseMove event on a Shape? > > I would like a "comment" type Text Box to be shown when the mouse is over a > given shape and make the shape 3D. > > Thanks in advance > >

If the cell interior is filled by standard format method, then: Private Sub Worksheet_Change(ByVal Target As Range) Set myRange = Sheets(1).Range("A1") If Target = myRange Then MsgBox myRange.Interior.ColorIndex End If End Sub This next one is a little tricky. It basically does the same thing but it only returns the setting for the conditional format and does not tell you if the ...

Hi I have written macro to compare two sheets. can any one help me to write macro - if there is data validation error then delete the cell value (leave blank in that cell) so when i run this macro it should check for data validation and if there is an error say date field is entred incorrectly then it should delete that cell value and leave the value blank. Thanks a lot in advance!...

I'm not sure if this is a Excel question or an Access question. I have a spreadsheet (call it "A") that links to data from several different spreadsheets. I have an Access database links to worksheets in "A", and some queries run from VBA that use linked tables. So when I run the VBA, it runs queries that refer to the linked tables, which in turn refers to the spreadsheet "A" which ...

Wierd that setting Application.Screenupdating doesn't work. However, you could minimize the Excel application's window with Application.WindowState = xlMinimized, and then put it back with Application.WindowState = xlMaximized or Application.WindowState = xlNormal when everything is done. -- J. Andrew Smith Senior Systems Analyst Standard & Poor''''s, NYC "omsoft" wrote: > ...

The icon "Toggle folders" did the trick. Sorry for wasting your time. -- TomThumb "TomThumb" wrote: > Now I have one list of modules linked to and followed by a list of > worksheets. If I click on the Project Explorer - (minus), all modules and > worksheets disappear. If I then click on the Project Explorer + (plus), all > modules and worksheets appear in one list. Can I ...

Assuming that conditional formatting will not allow you enough ability to change the format of the labels then you can use event code such as sheet change to format cells (or controls) as necessary. -- HTH... Jim Thomlinson "eggpap" wrote: > Hello, > > I have a workbook, see also my previous message, with labels on some sheets > whose caption I'ld like to control with some ...

As a side note, are you aware of the function MMult? Sub Demo() Dim m, m1, m2 m1 = [{1,2;3,4;5,6}] m2 = [{11,12,13;14,15,16}] With WorksheetFunction m = .MMult(m1, m2) End With End Sub HTH Dana DeLouis BEETAL wrote:[vbcol=seagreen] > Dear Per Jessen, > > tell you something! You must be a highly intelligent programmer. am i right > or not? > > Thank You ,Sir. > > ...

Hello, I am trying to make code work in 2003 and 2007. So I am looking at the fileformat. which is XlFileFormat (enum) what is used for office 2003? Const xlExcel9795 = 43 (&H2B) Member of Excel.XlFileFormat Const xlExcel7 = 39 (&H27) Member of Excel.XlFileFormat ??? thanks for any help

Ryan, Thank you for your help. I have one last element of this that I need help for. It does indeed grab the last 3 characters of the filename, but those appear to be the file extension. what would I use to strip off the file extension? Again-- thank you! "RyanH" wrote: [vbcol=seagreen] > Steve this is what I would do. This code will scan all the worksheets in the > active ...

Hello all: I would like to know how to get a web query search let's say google for info that are entered in excel. For example I have a zip code in excel in cell A1, then I want to have a macro that should get a web query and search in google for that zip that is entered in cell A1 and give me then the results. Please let me know. Thanks in advance.

Hello - I am awfully rusty in Excel. I currently am working in 2007. I need to write code that will save an .xlsm workbook without the macros. I also need code to save it to a particular file name and always that particular file name, even though it's going to overwrite the file. Any help will be most appreciated! -- Sheldon

Hello All, I have a group of data that was recorded 6 times every minute for a year. I need to only keep one row at the top of each hour. I wrote a script and have it running now. It checks each row and if the minute in that row is not 0 then it deletes it, if it is zero it deletes the next 5 rows then skips one row. I've had it running for about 10 minutes now and I'm through with ...

Hi everyone, I'm trying to clear data validation from a range of cells in all the sheets of a workbook. I've found various bits of code that are doing the same sort of thing as I need to do and Bob Phillips also helped [url]http://www.microsoft.com/office/community/en- us/default.mspx?dg=microsoft.public.excel.programm ing &lang=en&cr=US[/url] I should have perservered at the time ...

Hi all: I'm using the following code to format the page setup for a workbook, but as soon as I introduced it, the process time increased from 15 seconds to 3.5 minutes. Can anyone tell me why my code is so slow? DestWS is the worksheet in the workbook this code is acting on. There are 2 workbooks generated by my previous code and multiple worksheets that are created per workbook that...

hi all. I've modifed an existing macro to copy renamed worksheets in to a secondary workbook. I've read the KB file from MS that Jim Thomlinson has posted regarding this issue, and if I understand it correctly the problem mainly occurs when the user seeks to copy a worksheet in to the same workbook. My goal is to copy the worksheet in to another, existing workbook. wks.Copy after:=...

Hi I have written macro to compare two sheets. can any one help me to write macro - if there is data validation error then delete the cell value (leave blank in that cell) so when i run this macro it should check for data validation and if there is an error say date field is entred incorrectly then it should delete that cell value and leave the value blank. Thanks a lot in advance!...

I have a sheet in which there are text matters. I want to run a code, so that all the cells of the worksheet can be effected to change the first letter of the cell into capital. I was able to know with the web helps examples, by that I can do it manually with the cell reference one by one. the formula is as below : =CONCATENATE(UPPER(LEFT(A1,1)),LOWER(RIGHT(A1,LEN( A1)-1))) But I...

Greetings, I have a ComboBox that is loaded when the UserForm is Initialized. But sometimes I need to add a name to the bottom of the ComboBox list from a TextBox. I am getting this error message: Runtime error '70': Could not set the List property. Permission denied. Here is the code: ComboBox1.List(ComboBox1.ListIndex, 2) = TextBox1.Value I need the value of TextBox1 ...

Thanks, Joel Tried running your sub but hit with: RunTime error 438 Object doesn't support this property or method Debug pointed to this line: Set c = Sheets("X").Column("C").Find(what:=ID, _ LookIn:=xlValues, lookat:=xlWhole) (I'm using xl2003)