No announcements
-
17 VotesHow to ask a question efficiently in MSDN Visual Basic for Applications forum?
Thank you for visiting the MSDN Visual Basic For Applications (VBA) forum! :) The online problem solving can be relatively time consuming because it may ...Sticky | 3 Replies | 14778 Views | Created by danishani - Wednesday, March 14, 2012 12:19 AM | Last reply by Joohny - Wednesday, April 24, 2013 6:44 AM
-
0 Votes
-
1 Votes
Object library feature not supported (anymore) :( ...
0 colAttachments.Remove 1 Wend Set objAttachment = Nothing Set ...Unanswered | 10 Replies | 648 Views | Created by Duncan McCormack - Tuesday, February 07, 2017 11:30 PM | Last reply by BrePea - 4 hours 11 minutes ago -
0 Votes
Access 2013
I created a form called frmPubsMainTable and a subform called frmJOINPubsMainJournalAuthorsubform. I would like the field in the main form "FirstAuthorID" when update with data to ...Unanswered | 2 Replies | 49 Views | Created by akearse - Thursday, June 22, 2017 1:48 PM | Last reply by Edward Z - 5 hours 4 minutes ago -
0 Votes
Copying Excel columns and appending all to 1 sheet
Hi Folks - I posted earlier today but my requirements changed slightly so this is my final requirements and I hope you can assist. I have a Master "Utility" excel ...Unanswered | 3 Replies | 73 Views | Created by cdtakacs1 - Thursday, June 22, 2017 11:54 PM | Last reply by cdtakacs1 - 15 hours 30 minutes ago -
0 Votes
Macro
hello, I just want to ask if it possible to use Microsoft excel macro in combining two or more pdf file, that ask the exact location of the file? and if so, how its works, coz I try ...Unanswered | 2 Replies | 33 Views | Created by Eufracio Cabana - Tuesday, June 27, 2017 10:08 AM | Last reply by mogulman52 - Tuesday, June 27, 2017 4:13 PM -
0 Votes
System locale - vba (Excel)
Hello, W10 O2016, system locale set to en-US (microsoft recommends for corporate infrastructure:). Display language of W10: czech (special ...Unanswered | 1 Replies | 40 Views | Created by calidor1 - Monday, June 26, 2017 7:14 AM | Last reply by Peter Thornton (Excel MVP 2008-13) - Monday, June 26, 2017 4:43 PM -
0 Votes
Forms to Table - Copy and Paste Coding
Hello, I am very new to VBA, Access, and coding in general. I was assigned a project for work involving access and employee data to create an end Report with said data. My question ...Unanswered | 1 Replies | 74 Views | Created by intern123 - Friday, June 16, 2017 2:52 PM | Last reply by Hans Vogelaar MVP - Friday, June 23, 2017 7:35 AM -
1 Votes
Programmatically sign a macro - Macro signing automation
Hi All, Currently, we are doing signing the excel macro file manually, is there any way to automate this macro signing? Is there any ...Proposed | 7 Replies | 6487 Views | Created by Kirubanandam Venkatesan - Thursday, December 02, 2010 6:11 AM | Last reply by Marc--R - Thursday, June 22, 2017 7:46 PM -
0 Votes
Protect column in Excel table containing formula without limiting other table manipulations (eg. inserting rows, colapsing columns)
Hello, I have a table in excel 2013 that contains a column with formulas that I want to preserve. I don't want other users to manually edit the contents of this column, ...Unanswered | 11 Replies | 233 Views | Created by Newby to VBA - Thursday, March 23, 2017 7:05 PM | Last reply by OssieMac - Wednesday, June 21, 2017 4:57 AM -
2 Votes
Problem with scrollbars in VBA Editor
Hello Everyone, I've been coding in the VBA editor for more years than I care to admit. Very recently, I've run into a problem within the editor itself that is new to me. ...Unanswered | 25 Replies | 578 Views | Created by Richard55Jax - Wednesday, April 26, 2017 3:32 PM | Last reply by Richard55Jax - Wednesday, June 21, 2017 12:04 AM -
1 Votes
Need to lookup 2 columns in VBA Function
I need to use to lookup columns in from another sheet and return in a single cell VBA. My Data in Sheet1 is, P.No. REV ...Unanswered | 5 Replies | 138 Views | Created by DivyaS55 - Wednesday, June 07, 2017 10:12 AM | Last reply by Andreas Killer - Tuesday, June 20, 2017 3:37 PM -
11 Votes
Sorting An Array in VBA (without excel function)
Hi Experts, 1. I want to sort an Array in VBA. For strings, it should sort per alphabets, and ascending for ...Answered | 26 Replies | 130598 Views | Created by Ajay Check - Saturday, March 24, 2012 6:56 PM | Last reply by Andreas Killer - Tuesday, June 20, 2017 10:17 AM -
1 Votes
How to convert a part of a worksheet into txt.
Srs, Hello! I have to convert a range from a spreadsheet to TXT, in the code below it converts the entire spreadsheet, but I need that part of the spreadsheet to be converted to ...Answered | 10 Replies | 160 Views | Created by Cdilenes - Tuesday, June 13, 2017 11:41 PM | Last reply by Cdilenes - Sunday, June 18, 2017 7:35 PM -
2 Votes
VBA code to concatenate cells with IF statement
Hello VBA experts! I would like to check in if you can recomend a solution to my macro problem. So I am trying to write a code that will concatenate cells or words if a condition is met. My condition ...Answered | 2 Replies | 84 Views | Created by IamJackie - Friday, June 16, 2017 9:38 PM | Last reply by IamJackie - Saturday, June 17, 2017 5:09 PM -
1 Votes
Getting pattern after specific conditioned match
I have the below fields on email message: . . Description: We are going to perform maintenance work which affects your ...Answered | 1 Replies | 76 Views | Created by Mohammad Alshaikh - Saturday, June 17, 2017 1:22 AM | Last reply by Asadulla Javed - Saturday, June 17, 2017 3:50 AM -
0 Votes
Evaluating an If condition - variable not working
Hi Folks - I'm having trouble getting an If condition to work. The purpose of this script is check how many columns are in an excel ...Unanswered | 7 Replies | 73 Views | Created by cdtakacs1 - Friday, June 16, 2017 3:59 PM | Last reply by Bernie Deitrick, Excel MVP 2000-2010 - Friday, June 16, 2017 8:13 PM -
0 Votes
VBA Code to run Clean up Folder and Subfolders
I want to write some code in Outlook 2016 VBA to loop through some offline folders and run the "Clean Up Folder & Subfolders" command from the menu (Home Ribbon). However, ... -
2 Votes
VBA code to color code cell based on conditions from 3 columns
= 77. Appreciate in advance all the help or recommendations! 'Color code if it shows the ff results 'Col B: RAIL, Col C: either ...Answered | 5 Replies | 110 Views | Created by IamJackie - Tuesday, June 13, 2017 10:45 PM | Last reply by IamJackie - Thursday, June 15, 2017 2:37 PM -
0 Votes
Checkboxes, strings and arrays
Hi, I'm stuck. I have three groups of varying numbers of checkboxes on a form where the user can select 5 out of each group. Each checkbox represents a string value ...Unanswered | 4 Replies | 106 Views | Created by Bacardi84uk - Wednesday, June 14, 2017 8:14 AM | Last reply by mogulman52 - Thursday, June 15, 2017 2:29 PM -
0 Votes
Create and Select Named Range in Excel
I'm using Office 365 ProPlus. It's been several years since I worked with Excel VBA, and now I am struggling to achieve something that seems like it should be easy. All I want to do ...Unanswered | 1 Replies | 71 Views | Created by thomasm516 - Wednesday, June 14, 2017 6:47 PM | Last reply by Peter Thornton (Excel MVP 2008-13) - Wednesday, June 14, 2017 7:47 PM - Items 1 to 20 of 14118 Next ›
No announcements
