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 | 14763 Views | Created by danishani - Wednesday, March 14, 2012 12:19 AM | Last reply by Joohny - Wednesday, April 24, 2013 6:44 AM
-
0 Votes
Find and Replace Issue : MS Excel cannot find a match
Hi Folks - I'm running into an issue when performing a Find& Replace on multiple worksheets in the same workbook. What I do is populate (3) sheets in Workbook1 with ... -
0 Votes
Excel VBA Move through String Positions When a Match Found
I have to enter shipment commitment months to a column on a spreadsheet. I derive the month from a commitment streams with comes in the form of 1xS 1x1/1/17 2x2/2/17 3x3/3/17. The first ... -
0 Votes
Search for any heading style
I'm writing a macro in which I need to search the document (which is one very long table) for the next heading. It doesn't matter which heading style, just whichever heading appears next in the ...Unanswered | 1 Replies | 39 Views | Created by hacksu - Friday, June 23, 2017 9:32 PM | Last reply by Graham Mayor - Saturday, June 24, 2017 11:54 AM -
0 Votes
Creating multiple workbooks from a master file
I have an Excel file which contains transactions processed by multiple entities. I need to create a separate file for each entity by grouping multiple lines using column E which contain entity ...Unanswered | 1 Replies | 38 Views | Created by Leo Veynberg - Friday, June 23, 2017 9:39 PM | Last reply by OssieMac - Saturday, June 24, 2017 4:54 AM -
0 Votes
Get specific paragraph in word file through regex using VBA
Get specific paragraph which one starts with square bracket,numeric value after space in paragraph of word file. how to find through regex using VBA can you ...Unanswered | 2 Replies | 38 Views | Created by Soniya Singh - Friday, June 23, 2017 4:45 AM | Last reply by Graham Mayor - Friday, June 23, 2017 11:48 AM -
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 | 62 Views | Created by intern123 - Friday, June 16, 2017 2:52 PM | Last reply by Hans Vogelaar MVP - Friday, June 23, 2017 7:35 AM -
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 ... -
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 | 6434 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
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 ... -
0 Votes
Navigation Pane Macro
Hello, I need a navigation pane macro that will automatically set the search bar to search for comments (word comments). As in, doing it manually, you would go ... -
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 | 219 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 | 536 Views | Created by Richard55Jax - Wednesday, April 26, 2017 3:32 PM | Last reply by Richard55Jax - Wednesday, June 21, 2017 12:04 AM -
0 Votes
Auto Refresh/Calculate Worksheet Issue
Hello all I am attempting to create a Worksheet 2 that tracks changes to the work roster on Worksheet 1. The roster is managed by filling different colour ...Unanswered | 2 Replies | 47 Views | Created by DanJ85 - Tuesday, June 20, 2017 12:55 AM | Last reply by Bernie Deitrick, Excel MVP 2000-2010 - Tuesday, June 20, 2017 9:17 PM -
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 | 130 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 | 130193 Views | Created by Ajay Check - Saturday, March 24, 2012 6:56 PM | Last reply by Andreas Killer - Tuesday, June 20, 2017 10:17 AM -
0 Votes
How to set the x, y min/max for a plot
For a plot, I am looking for a way to use a variable to set the xmin, xmax, and ymin, ymax of a plot. For example Myxmin = xmin of the plot ...Unanswered | 4 Replies | 70 Views | Created by illmaticfor - Monday, June 19, 2017 4:03 AM | Last reply by Peter Thornton (Excel MVP 2008-13) - Tuesday, June 20, 2017 8:36 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 | 147 Views | Created by Cdilenes - Tuesday, June 13, 2017 11:41 PM | Last reply by Cdilenes - Sunday, June 18, 2017 7:35 PM -
1 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 | 72 Views | Created by IamJackie - Friday, June 16, 2017 9:38 PM | Last reply by IamJackie - Saturday, June 17, 2017 5:09 PM -
0 Votes
Find and replace a non-ASCII character
I want to find Ŋ and ŋ characters in my Excel document and replace them with their respective codes Ŋ and ŋ Ŋ and ŋ are outside ...Answered | 1 Replies | 79 Views | Created by AfricaJohn - Saturday, June 17, 2017 4:21 AM | Last reply by Andreas Killer - Saturday, June 17, 2017 8:40 AM -
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 | 65 Views | Created by Mohammad Alshaikh - Saturday, June 17, 2017 1:22 AM | Last reply by Asadulla Javed - Saturday, June 17, 2017 3:50 AM - Items 1 to 20 of 14124 Next ›
No announcements
