vbe

Hey everyone! I am currently writing code to eliminate blanks in a table.. I have to set p = to various worksheets, but I continue to get type mismatch errors. I have tried re cataloguing them to Sheets() or Activeworkbook.Sheets(), etc. but to no avail... can anyone tell me what I am doing so...

I am trying to add a connector to a selected shape. I want the user to be able to select the shape and then run the VBA that will use the selected shape and add a connector. Is this possible?

I have been trying to figure this out for 3 days and am at the end of my rope. I am designing a spreadsheet for a construction firm. The workbook contains an the estimate, client proposal and the PO's for 3 different vendors. On the estimate I have a dropdown list for the vendor, category...

Hi, Completely new at this and just having a play to see if it is something I can use at work. I have discovered this: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Intersect(Target, Range("Insert cells or range")) Is Nothing Then Else MsgBox...

I have 3 different workbooks that I'm working with. 2 of the workbooks are reports that are automatically saved to a random temporary internet file folder. I was wondering if I can somehow activate the 2 workbooks without knowing the file path since they will saved to a random folder every time...

Dear All, I have this table contain both male and female information as below. I want to manipulate them to a new table with one attribute added as below. My input: <colgroup><col span="2"><col><col span="2"></colgroup><tbody> Male Female Time Tall Comment Jim 3/12/2016 188 Nicky...

Hey, Has anyone ever run into the issue of not being able to resize the code window? I've attached an image and for the life of me don't know what I've done or how to reverse it. Image here.

I explain what I want the macro to do in the picture and provide a basic layout of how the sheets are exported from an internet application. I wrote a macro to format the sheets from an unreadable formatting to a user-friendly format. However, I cannot figure out how to change the whole row's...

Whenever I open the VB Editor all the code windows for (almost) all my add-ins and personal WB always open and totally clutter-up my current project. Is there a way to automatically close them ALL (I'd individually re-open the current project ones I need to work with) at once when the VBE opens...

<tbody> I have created a vba code that creates a new .xlms file, adding some code to that file and then my problem is that i cannot protect the VBPoject of that new file. Instead, i wrongly password protect the current VBProject (not the new...

Target Code: ' Insert Add-In menu with generate button and check trial/retification on workbook open Private Sub Workbook_Open() ' Call Trail/Rectificaton function Call objClsGeneral.fnTrial_OR_Recertification_versionCheck("Recertification", "09-Jan-2015", "SomeAppName") Set objcmd =...

I have one module with all the public constants stored and cleared. When I am running a module with refers to this module, I can see neither the module nor its values. For me it seems like the VB-Editor is only able to show one module in "Locals" at the same time. Until now I have used the...

Hello out there. Can someone post a code example on how to show VBE userform with multipage via VBA, containing list of functions in current project, each page for each module correspondingly. I know how to create userform via VBE, extract module and function names to arrays and put them in...

Hi everyone. I have a database full of part numbers for example <TBODY> 0EV2310A06G01JU:S5065</SPAN> </TBODY> These can vary to having a vareity of symbols/letters/numbers (I am not sure if this makes a difference!) I am looking for help to writing a macro to run a report to show the top...

Password protected VBA module causes Excel to crash on debugs. Macros work fine if I open VBE and enter my password. I'm using Range.("This range does not exist").Select to force a debug. If I run my macro without entering my module password, the debug window appears and Excel crashes. If I...

I accidentally named one of my variables "count" (I'm new, give me a break.) As a result every time I try and use the Count property VBE autocorrects it to be "count" instead. For example rowCount = Selection.Rows.Count Will be auto corrected to read: rowCount = Selection.Rows.count The...

hi Guys, i have just found the treeview function within the user forms and would like to build one. i have looked at a few examples of the data needed but cant figure out the codes to import the information. to simplify it can someone please send me the makro or code for the following...

Hello, I have an addin that creates mulitple reports and since each of the report modules are updated by a different person, I have code that will delete the old module and import the new one for each one of the reports. The process goes as follows: Delete each of the old modules. Import...

Hi all, I have some code which creates new sheets based on a list elsewhere in the workbook. They all create fine. However, when I look in the code/VBE, I can't see any of the created sheets, except the one currently selected in Excel. If I manually go through each of the sheets in excel...

I've done this before in Excel 2003 but I can't seem to do it in Excel 2007 because the control isn't there in the additional controls list. In Excel 2003 it was called Microsoft Office Spreadsheet 11.0 and when ticked gave an extra item on the control toolbox which allow you to draw an excel...