-
- Watch a region
by zipmmcs
- 1 Replies
- Last post
by bi-lya
- Hi! I would like to perform such an action that provides me the actual date in the activated cell. I saw somewhere the following: the user clicked into a cell and the current date appeard there, but only if the line before was filled. If the line before was empty nothing happened. Could you help me Thanx in forward!
-
- VB in Excel-setting chart source data
by jk2880
- 3 Replies
- Last post
by jk2880
- I am attempting to create a macro that automatically creates charts for columns of data in a different sheet.
I would like to replace the "hard coded" range property with a variable range(cells,cells) in order to cycle through several different columns of data.
With the following line of code, I receive the error "Run-time error '1004': Method 'Cells' of object '_Global' f
-
- randomizing the contents of Excel cells
by Josh Ord-Hume
- 6 Replies
- Last post
by PYA_Ferro
- I am trying to create an Excel macro that will look at the contents of cells A1, B1 and C1 and 'randomize' their order. So, if the contents of A1, B1 and C1 are "1", "2" and "3" respectively, they might end up as " 2 ", " 3 ", " 1 " or " 1 ", " 3 ", " 2 " once the macro has been run. Any ideas gratefully rece
-
- Lack of mouse scroll wheel support in VBA
by Tony Toews
- 12 Replies
- Last post
by SusanBaroody
- Folks The mouse scroll wheel does not work in VBA. This has always puzzled me as to why this support does not exist since Office 2000. This problem was originally caused by a MS Mouse driver change that I'm told was communicated long in advance to other MS folks. This problem has existed for several versions of Office. As far as I'm concerned this should've been fixed in the Off
-
- Subtract a date
by F&#225
- 6 Replies
- Last post
by Fábio Nobre
- Hi, I'm creating a aplication whith Visual Basic and I need to subtract dates, now I'm using a simple method: Subtract a Month: ---------------------
If optmes.Value = True Then
(DateValue(Now) - 30) & " " & TimeValue(Now) Subtract a Year: ---------------------
If optano.Value = True Then
(DateValue(Now) - 365) & " " & TimeValue(Now) But this met
-
- Inserting additional chars into a string....
by Guustaaf
- 2 Replies
- Last post
by Guustaaf
- Hi pals and gals,
Could someone help me with the following problem
I have a userform in wich the user types personal data of new employees.
Now i want the text in the textboxes to automaticly change into the correct format at BeforeUpdate.
example:
Private Sub txtVoorletters_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean) txtVoorletters.Value = StrConv(txtVoorletters, vbUpperC
-
- Obtain Unique Work Units via SQL
by AlDeb
- 14 Replies
- Last post
by AlDeb
- Below is the SQL I have for a Query. The results of my query are below the code. Everything works great except for the WorkUnit totals.
I am getting the total Records for the date range and I really need the Unique workUnits for the date range. For this particular daterange I
have a total of 197 WorkUnits but in reality there really are only 89 Unique WorkUnits.
In the example below on on
-
- MODI on Office 2007
by Reuven Pardes
- 0 Replies
- Last post
by Reuven Pardes
- hi
i'm trying to emigrate VBA macros (with MODI ) from office 2003 to office 2007
1. does anybody know if there are changes in the object model
2. How can I access the MODI's Help. (i did installed it but can't see it).
thank you
reuven
-
- Listbox scroll problem
by DeathSurfer
- 3 Replies
- Last post
by Dan6845646+5414532
- Duuuuudes:
I have a problem with scrolling to the bottom of a listbox in excel '03. I'm using the listbox control in vba, not the excel forms control. Anyway, when I scroll to the bottom of the list, it won't let me see the last item in the list box. It will stop one short and will actually have a space below the scroll bar that looks like it could scroll down one more list item but won't.
-
- How to write code for dynamically (programitically) generated combo boxes ?
by Sajagesh
- 0 Replies
- Last post
by Sajagesh
- How to write code for dynamically (programitically) generated combo boxes (excel-shape object) in excel macro If the combo boxes are named using the cell reference on which these combo boxes are placed and linked. For example, a combo box, placed over the cell "G23", will be named as G23.
-
- Compatibility Issue Excel 2000 and Excel 2003
by rcash864
- 11 Replies
- Last post
by Jon Peltier
- I wrote a macros for a customer in Excel 2003. He didn't tell me he used Excel 2000 until after the project and like an idiot I forgot to ask. The macros will not run on his version of Excel 2000. A compile error shows up.
So he got a version of Excel 2003 and the macros will still not work for him. I have tested this macros on other machines using 2003 and they all work correctly for me. I liv
-
- Action Pack Question
by Tone Southerland
- 12 Replies
- Last post
by Mark.Rowe
- I am interested in the Action Pack. I understand that it comes with the Vista upgrade, not the full edition. I do not have 10 licensed copies of XP Pro to upgrade from. So does that mean I will need to purchase a licensed copy of XP Pro for each machine that I want to put the Action Pack upgrade version of Vista on
-
- Making an array in Excel with the file names of a particular folder
by Bartyb
- 5 Replies
- Last post
by Peter Mo.
- Hello, could anyone help me, I already have a macro in Excel that uses an array of filenames to process data, but so far I have to enter the filenames manually.
Basically, I want the macro to simply create an array in Excel with the files names and their extension (which will always be the same) located in a particular folder, sucha as:
Filename1.ext
Filename2.ext
...
Filename13
-
- Excel Command Button - Hide multiple sheets based on IF statement
by suznal
- 9 Replies
- Last post
by suznal
- I have a sheet in a workbook that acts as a sort of table of contents.
All of the sheets in the workbook are listed in a column and the column to the left of each worksheet name is either blank or contains an ¡®X¡¯ depending on whether the sheet was used on a particular occasion.
I have a command button on the page that will hide a sheet if a particular cell is empty. Currently this only wor
-
- .mdmp files not being created
by David Ching
- 14 Replies
- Last post
by JPSA
- Hello, Under what conditions is the .mdmp file created or not I have written an app that (deliberately) dereferences a NULL pointer, but the generated error report does not have the "Files that help describe the problem" section when listing the report from the Control Panel "Problem Reports and Solutions". Viewing other reports that had been put there, some of them have the f
-
- Calling .Net dll in an Excel macro in VB
by Asim Patnaik
- 1 Replies
- Last post
by Bruno Yu - MSFT
- Hi,
I have a .Net dll which fetches data from the server. The data is in the form of a table. This data has to be displayed in an excel file. The business user only uses excel files and writes macro to fill the excel. So I have created a class which implements a certain interface and have built a dll out of it. I register this dll using Regasm.exe. Then I write the macro to fill the excel. Fo
-
- Using Listview or Flexgrid Control in VBA
by Dongs
- 1 Replies
- Last post
by Jon Peltier
- Hi ,
Please provide some insight in using Listview or Flexgrid Control , as i am little bit stuck in coding. I am not able to find any property that allows adding item to listview or flexgrid.
Thanks,
Dongs
-
- Office Communicator 2005 sign-in name, auto populate after install somehow?
by markm75c
- 14 Replies
- Last post
by Mike@ALS
- Does anyone know of a way to have the sign in name in communicator, auto filled in after an install or doing the install..
Basically every user has the same format.. first.lastname@domain for the login.
I'd prefer to find a way to have this info auto entered after the install when it first tries to open.
I'll be using communicator as a "broadcast" method.. and alot of users prob
-
- Mouseover event on shapes (Excel 2003)
by jrc1378
- 1 Replies
- Last post
by Jon Peltier
- Can I set a mouseover event in VBA on a shape (copied picture)
I have a module that copies an inserted image from one sheet to another sheet based on cell values denoting the placement of the copied image.
The copy is then handled as a shape to set Name, Alt Text, and so on and the sheet is saved as a web page for browser viewing.
Is there a way to set a mouseover event for a
-
- Increase prompt in message box
by une
- 3 Replies
- Last post
by Jon Peltier
- I have a userform that contains a command button that when clicked displays a message box. This message box contains help notes for the user. However I can't quite fit all the text in. When displayed, the message box cuts off the last couple of sentences. I think this is because my help text is the prompt in the message box and it is too long (> 1024 characters). How can I get a few extra sente
-
- Need an event
by rtmos
- 3 Replies
- Last post
by Cringing Dragon
- I need an event that triggers when I move from record to record on a subform using the navigation buttons. I thought "current" would do it but it never seems to fire for a subform. Is there such an event Thank you
-
- How can I change a seires chart type in Pivot Chart?
by lyp_sj
- 1 Replies
- Last post
by Jon Peltier
- CLV Export
CLV FN
CLV FNN
CLV Main Milk
Demand
SOC
Demand
SOC
Demand
SOC
Demand
SOC
1724
2000
644
2000
5603
2000
2192
2000
1720
2000
615
2000
5813
2000
2271
2000
2293
2000
604
2000
5476
2000
2161
2000
2156
2000
516
2000
6290
2000
2201
-
- Powerpoint 2007 textframe.autosize
by boland0980
- 6 Replies
- Last post
by jtburchfield
- Hi,
I am have a VBA script to generate a powerpoint slideshow from data in a SQL Server. It works perfectly on office 2000 and 2003 but not with office 2007. After some debugging it appears to me that the offending line is when i set the textframe.autosize property.
After looking through the msdn library I noticed that there is no Powerpoint reference manual under 2007 office suites.
-
- error creating Excel application object
by srendoherty
- 1 Replies
- Last post
by Andy Pope
- Hello World,
I am using VBA from an application call MicroStation to open a document in Excel and am having problems creating the Excel Application object. The line:
Set xlApp = GetObject(, "Excel.Application")
results in the message Run-time Error '429': ActiveX component can't create object.
The documentation indicates a number of possible problems, but none of them seem li
-
- Validation list macro
by hysenlici
- 4 Replies
- Last post
by srinivasanng
- Hi
I need help...
In my drop-down validation list when I select let's say "Apple", I want a message box to come out, only for "Apple", let's say" Attention: You selected apple. We remind you that this item..."
If I select, let¡¯s say "Onion" nothing should be came out.
Could someone help me with this, I think by runnin