vbe

How can I store a lookup table in vbe module instead of a worksheet (hidden or visible). Is this possible? Or, could I pull the contents out of an existing lookup table, delete the workhseet, and have vba add a new worksheet and recreate the table? - Thank you, Rowland

Hey guys, this is my first post and I really hope someone will be able to help me. So here is a little background on my project. I am an environmental engineer doing different risk/health assessments on various sites. My excel (2007) file has 4 sheets. The first three are based on increasing...

I'm brand new to the idea of macros, but I'm hoping this can be done without too much complication. I'm a teacher and I'm building a spreadsheet for a lesson. The students enter a yearly salary in box A. Then there will be several sections ("Housing", "Clothes", "Entertainment", etc.). Each...

Suddenly yesterday my Excel 2007 (on Windows 7/64) started behaving funny. When I open VBE the Project Explorer shows all "objects" in one long list in alphabetical order. Modules, forms, sheet-objects, even "ThisDocument" is placed in the same list. No headings except for the top one...

I'm trying to assign a keyboard shortcut (Ctrl+Shift+C) to comment a block of code in the Visual Basic Editor. How do i go about doing this? I know there is a toolbar with a button for it, but **** the mouse... I want a keyboard shortcut! Thanks in advance...

Hi all. This has been intriguing me for years and i've looked and asked everywhere but nobody seems to know the answer. On most operating systems, subclassing office applications from within VBA crashes the application and worse yet, it can downright lock the whole system. this is a known...

Hi all, I have long looked for code that makes the mousewheel scroll the VBE code panes but I could only find some external programmes or dlls written in C. with a bit of trial and error and a couple of tricks, i have put together this code done purely with VBA as you can see which I hope...

Hello, In this post (http://www.mrexcel.com/forum/showthread.php?t=39411) Tom Schreiner shows us a variation on Chip Pearson's VBE explanation, to run a procedure with a custom made command in the VBE menu or toolbar. I am experimenting with this and run into the following problem: I want to...

Hi I hope someone out there can help me. I'm trying to merge rows in a spreadsheet that contains about 700-100 rows and 8 columns of data. There is nothing to identify the groups except its vertical linear position so any merging of data that occurs cannot affect adjacent cells. The data is...

Hello. My problem is how to write a formula in vb. I searched everywhere, and nothing I write a code, but i get overflow error. Option Explicit Const Pi = 3.14159265358979 Const B = 2 Const C = 1.5 Const D = 8 Const E = 4 Private Sub chkRezultat_Click() Dim X As Single, Y As Single, Z As...

Thanks for reading this post. I am programmatically looping through N workbooks (open workbook, process, close workbook). When I close the workbook, I am left with a "footprint" of workbook in project explorer, even though the workbook itself is closed. This is causing problems as well as...