Summary: I recently tried to port a VBA program from Win NT4 to the Mac, and discovered that the capability to view local variables was absent on the Mac v...
Summary: i have been trying for days to create a multiplication table in Excel using Visual basic it is driving me mad!! i has to be a 12x12 grid with each row...
Summary: Guyz, I'm trying to use a field in Excel 2000 using Access VBA. Does anyone knows of a program that might help, or has an idea how to do it? Thanks ...
Summary: My friend wrote a short VBA macro for me (Excel), to calculate something. Problem is as the values in the cells it references change, it doesn't upda...
Summary: hi, i am trying to open a whole bunch of files in a program using VBA backend with excel frontend, and do a bunch of common operations on those files....
Summary: I am quite enamoured with VBA in excel, love it for creating macros but the process of the programming seems limited, only allowing me to use Excel as...
Summary: i have been given the following questions if anyone could help with a solution to each i would be most greatful because i am new to using vba in excel...
Summary: W-Fred is right. About programming. Yes you can do it in Excel VBA Better do it in Access and put a neat frontend. Else put values in cell and identif...
Summary: hello everybody i posted earlier about this but i might not have been very clear(mod's can delete the last post if they want), what i want to do is a...
Summary: hi i am trying to write a code that differentiates between a 0 and a blankcell in an excel sheet. the code : Public Sub test() If ActiveCell = "" Th...
Summary: I have a form in Excel that I have to print a zillion of. The problem is each print out has to have a unique form number for tracking purposes. The nu...
Summary: In an excel worksheet, I have 10 individual command buttons that perform a calculation. However, I was also looking to add another button to the shee...
Summary: Try these two lines: Rows("1:1").Copy Windows("Book2").Range("A1").PasteSpecial Paste:=xlValues, Transpose:=True The operation to convert between hori...
Summary: Hi I was wondering if anyone knows how to collect data from excel, and code it in VBA so it transfers it into a combo box in VBA, because i'm doing...
Summary: Can anyone help me construct a VBA code in Excel that would check if an external application (not Microsoft) is open or not? If it is open, can the co...
Summary: Need help with VBA and excel. I'm trying to write a macro for excel, with multiple combo boxes. When populating these boxes, I would like to store the...
Summary: you are using the features already installed in excel to send mail, you would need to program the outlook 9.0 object, and create an email from scratch...
Summary: I'm working with VBA in excel and am wondering if you can select multiple sheets. Manually you can select multiple sheets by holding down ctrl. I kn...
Summary: Hi I need to know how to give value to cell from another cell in VBA . Now the value is a date and it needs to be counted up until the end of the mont...
Summary: Can anyone tell me how to run an exe, with parameters (eg. C:\cmd.exe p1 3), in VBA for Excel 97. Up until now I've been putting the command into a ba...
Summary: I need to be able to check if an application is running from VBA in an Excel spreadsheet. If it isn't, I need to start the app. Are there VBA function...
Summary: Ok, what is your prob? Don't you know how to record a macro in Excel and then review the recorded code in VBA???? It will help you alots in solving su...
Summary: Hello there, ok, i have made an excel macro which when someone selects a option from a drop down menu, output is generated accordingly.. problem is t...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
