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 | 16029 Views | Created by danishani - Wednesday, March 14, 2012 12:19 AM | Last reply by Joohny - Wednesday, April 24, 2013 6:44 AM
-
3 Votes
MS Outlook data to be captured automatically to Excel
Hi, First of all i would like to state here is that i am a non-technical person, i.e. from the Medical background. But, i handle the work of ...Answered | 17 Replies | 6614 Views | Created by Kuljeet Bhambra - Tuesday, July 23, 2013 4:29 PM | Last reply by Graham Mayor - 4 hours 39 minutes ago -
0 Votes
Split a workbook in multiple workbooks, then split those workbooks into multiple sheets - VBA
I would really need help with something. I managed to split a workbook in multiple workbooks after a criteria. Now I have 6 different workbook, but I need each of them to split in ...Unanswered | 1 Replies | 23 Views | Created by Simena23 - Monday, August 20, 2018 8:05 AM | Last reply by Alex Li-MSFT - 22 hours 53 minutes ago -
0 Votes
Dictation cleanup macro available?
In another question I bemoaned loss of an "important macro." That macro was designed to compensate for the rather erratic output of the dictation application that comes with MS ... -
0 Votes
Where, oh where, did my macros go?
After working for a week on a macro that's pretty important to me, I now find that it, along with all other macros that I've created, are now gone. I suspect that the problem is ...Unanswered | 0 Replies | 34 Views | Created by Alan Carl Nicoll - Saturday, August 18, 2018 10:08 PM -
0 Votes
Userform disappear after calling FSO and opening a document --> remaining code stop executing
Hello, I have a Word macro composed of several userforms. All userforms have a "Browse" button to select an .rtf file. However, this button is only the first part of a ...Answered | 5 Replies | 42 Views | Created by Athlagan - Wednesday, August 15, 2018 11:14 PM | Last reply by Athlagan - Friday, August 17, 2018 4:14 PM -
7 Votes
how to select next visible cell in excel using vba
Hi there, Using vba code, I want to select a cell that has been ...Answered | 17 Replies | 49903 Views | Created by BKNLPRASAD - Wednesday, October 19, 2011 5:40 AM | Last reply by Martin V1234124 - Friday, August 17, 2018 2:54 PM -
1 Votes
VBA - Filter List Box - From TextBox Search - Run Macro
Hi friends, I am trying to make my TextBox1 work with my ListBox1 to Filter Search ...Answered | 14 Replies | 6488 Views | Created by Dan_CS - Monday, January 23, 2017 3:23 AM | Last reply by BECSE - Friday, August 17, 2018 8:46 AM -
0 Votes
Need Help VBA Find Certain Value
Hi, I have a set of data in which i want the VBA to automatically find certain concentrated value & paste it into another column for example as below. I want the code ...Unanswered | 1 Replies | 25 Views | Created by Atreus91 - Thursday, August 16, 2018 12:23 AM | Last reply by OssieMac - Friday, August 17, 2018 6:41 AM -
0 Votes
Run a subroutine via a variable
I want to be able to run a Sub by variable, sorta like this: Sub zXMacro() ' Alt M: Temporary macro key; use Alt-Shift-M to define If ...Answered | 2 Replies | 39 Views | Created by Alan Carl Nicoll - Wednesday, August 15, 2018 7:02 PM | Last reply by Alan Carl Nicoll - Thursday, August 16, 2018 1:11 AM -
1 Votes
Add items to MS Word document footer using VBA
Hi- I'm trying to add the following to the footer in a Word document: - Printed (current date) Left justified - Part number (entered on the document properties ...Unanswered | 7 Replies | 11549 Views | Created by Propman07 - Thursday, February 3, 2011 1:50 AM | Last reply by MHagesfeld - Wednesday, August 15, 2018 6:25 PM -
0 Votes
internet access difficulties
am having difficulties accessing internet on my lumia 640 windows phone version 8.1 to an extent that I cant even reset , it give me feedback to say couldn't turn off reset settings , check your ... -
1 Votes
Just can't figure it out
I've followed the instructions and did a copy and paste for the code. If I protect the sheet with a password, I get asked every time I enter something in the cell for a password. I really only want ...Unanswered | 2 Replies | 51 Views | Created by SadieNegan - Thursday, August 9, 2018 10:30 PM | Last reply by SadieNegan - Tuesday, August 14, 2018 5:23 PM -
0 Votes
Mandatory Field Excel (via VBA)
I would like to launch a message box / notification whenever a cell is empty (if another cell in the same row is not empty). In other words: when a cell in ...Unanswered | 2 Replies | 42 Views | Created by DieterDJ1 - Monday, August 13, 2018 3:16 PM | Last reply by Wouter Defour - Tuesday, August 14, 2018 9:11 AM -
0 Votes
prevent CUT/PASTE NOT COPY /PASTE
I only need to prevent CUT/PASTE NOT COPY /PASTE This code prevent both of them: Aplication.CutCopyMode=False Is there a way to ...Unanswered | 1 Replies | 52 Views | Created by Josephperi - Monday, August 13, 2018 11:14 AM | Last reply by Wouter Defour - Monday, August 13, 2018 1:30 PM -
3 Votes
How can I code VBA to select a dynamic range, and insert a data table?
PROBLEM SUMMARY: I am using Excel 2007. I would like to use VBA to convert a dynamic range into a data table. Manually, this is achieved by selecting the range, ...Answered | 3 Replies | 20265 Views | Created by Victor Sines - Sunday, June 12, 2011 9:50 PM | Last reply by AmjiBhai - Monday, August 13, 2018 5:09 AM -
0 Votes
Bring picture to front
5 Then Set xRg = Target.Offset(, 0) With sPic ...Unanswered | 2 Replies | 64 Views | Created by BrianDove32 - Saturday, August 11, 2018 8:37 PM | Last reply by OssieMac - Monday, August 13, 2018 4:38 AM -
0 Votes
Merge 2 different named PDFs (but a shared string) from 2 different folders and merge into 1 PDF.
Thanks for anyone that will be able to help. I'm starting with no knowledge of VBA/Macros in Excel since our Macro expert in the office will be ...Unanswered | 5 Replies | 82 Views | Created by IT Urgent Help - Tuesday, August 7, 2018 4:11 PM | Last reply by mogulman52 - Friday, August 10, 2018 10:36 PM -
0 Votes
Force Enable macro in Word Document
I need Client to enable macros before editing in word documentUnanswered | 1 Replies | 37 Views | Created by mokmaal - Friday, August 10, 2018 12:52 PM | Last reply by Hans Vogelaar MVP - Friday, August 10, 2018 2:15 PM -
0 Votes
Prevent Copying and Pasting entire sheet
We have several users who copy and paste data from one worksheet to another by selecting the upper left intersection of the row and column (gray cell area left of column A and top of row 1) instead of ...Unanswered | 1 Replies | 41 Views | Created by James N San - Thursday, August 9, 2018 8:49 PM | Last reply by Luca Brasi - Friday, August 10, 2018 7:57 AM -
14 Votes
How do you find out the Windows User Name from VBA
We log onto our network with a three letter user name e.g. ADG. Can I return the user name of the person opening my Access Database with VBA? I want to customise the options ...Answered | 15 Replies | 181552 Views | Created by ADG - Friday, April 28, 2006 3:39 PM | Last reply by JamsRHickok - Thursday, August 9, 2018 7:14 PM - Items 1 to 20 of 14848 Next ›
No announcements
