VBA QUESTIONS

Any of those help I would suggest using a simple DLookup expression for this task, for example, assuming that the password entered by the user is stored in a variable pwd, you might use:

TAG : vba

Date : January 11 2021, 02:18 PM , By : Valakor

How to hide an ActiveX Command Button when printing a word document?

I wish did fix the issue. I assume you are having ActiveX Command Button in word and using user form entered data gets feed in corresponding fields and you are closing user form and then trying to print document and printed file should not have Activ

TAG : vba

Date : January 11 2021, 02:18 PM , By : user3098607

VBA operator Not Like

wish of those help I am using a filter on a form currently: , A couple of issues with your current code:

TAG : vba

Date : January 09 2021, 02:14 PM , By : Scorpionidas

Why is my vba code returning back the placeholder text

this will help Given what you write, my approach to this would be to check the placeholder text and compare the content control's content with that. If they're the same, it's as if the content control had no content.Note that I'm unsure what is inten

TAG : vba

Date : January 08 2021, 10:52 AM , By : user3097354

Recursive function returning empty string

This might help you A proper recursive function doesn't need a specific exit condition. You just stop calling the function recursively, and it exits.However, if you want to explicitly exit, you can use Exit Function.

TAG : vba

Date : January 08 2021, 03:18 AM , By : user3097134

How to switch between windows with VB?

help you fix your problem I think your issue might be due to the difference between documents and windows. Windows can be multiple "views" into one document (you'll see a name like Document1:1, Document 1:2, etc) or into multiple, different documents

TAG : vba

Date : January 07 2021, 07:50 AM , By : user3096461

In Access VBA how does one keep a textbox active and select all its contents after Enter key

it helps some times The solution I came up with is to intercept the Enter key press. It is important to cancel the event, otherwise the Enter key will remove the selection.

TAG : vba

Date : January 02 2021, 06:48 AM , By : Mario

How to programmatically access "message bar" in Outlook?

it fixes the issue The area you are referring to is used to implement Mail Tips. Although you can create custom ones through the Exchange Admin Center , they cannot be interacted with via code.Manipulating Ribbon controls to show states or user messa

TAG : vba

Date : January 02 2021, 06:48 AM , By : Mohammad nasim

Turn off "The record source specified on this form does not exist" warning

To fix this issue You could leave the RecordSource empty or assign it some (empty) dummy record.When you set the RecordSource to its actual value, the subform will automatically requery.

TAG : vba

Date : January 02 2021, 06:48 AM , By : Madhusara Maheshka

Replacing text with StoryRange on Word VBA makes it briefly unresponsive

fixed the issue. Will look into that further Your code is lacking context - specifically regarding footerfindreplace.Item(i).FND and footerfindreplace.Item(i).replc. You're code is also processing all storyranges (which includes headers footers), th

TAG : vba

Date : January 02 2021, 06:48 AM , By : S. Yong

Access VBA: Shell command broken in one particular database

fixed the issue. Will look into that further The culprit was our anti-virus software! UGH!Why did it work in one database and not the other then? I'm told that years ago, anti-virus exceptions were made for my computer for the one database but not th

TAG : vba

Date : January 02 2021, 06:48 AM , By : Scott

How do I replace one variable with another for an entire column

Any of those help Single is a data type used for describing "single-precision floating-point numbers".You want String.

TAG : vba

Date : January 02 2021, 06:48 AM , By : Segio

Access error 2683 - There is no object in this control

I hope this helps you . I've read that the new versions of Office don't support this anymore and I should use the native datepicker.

TAG : vba

Date : January 02 2021, 06:48 AM , By : Dries De Witte

The code in this project must be updated for use on 64-bit systems

it should still fix some issue Upgrading companies software without extensive test is amateurish!But if that error message is the only problem you are lucky. You need to convert the api arguments declaration to x64, what usually means change allLongd

TAG : vba

Date : January 02 2021, 06:48 AM , By : Ravindra Jain

Nested dictionary object not found

I hope this helps . Not a complete answer -- I set up an example without the MS Access-specific parts and the logic in your code seems to run fine. As near as I can tell, there's no real difference in the logic below and your code above. Does this ex

TAG : vba

Date : January 02 2021, 06:48 AM , By : ParanoiaComplex

Is it possible to display a userform and executes a code bellow the .show method?

Does that help I want to display Userform2 from Userform1 then continue executing some code in Userform1 WITHOUT unloading Userform1 , Not sure that's what you want, but this would do what you describe:

TAG : vba

Date : January 02 2021, 06:48 AM , By : dtjr

How do I properly use if/then for a bolean value in order to make an object visible?

I think the issue was by ths following , Handle the control's Change event, and then you can assign to its value:

TAG : vba

Date : January 02 2021, 06:48 AM , By : Karina Kirby

Mergefield for objectname of PDF using Access and VBA

fixed the issue. Will look into that further Accomplish this by concatenating static text with variable input.Can reference controls on form that have values input/selected by user. If you want project name as well as month/year:

TAG : vba

Date : January 02 2021, 06:48 AM , By : ranga ravindra srira

VBA code for giving slides a constant name

Any of those help @Asger's suggestion would work but a more consistent approach (IMO) would be to use tags. Any presentation, slide, or shape on a slide can have one or more bits of text attached in the form of a tag.For example:

TAG : vba

Date : January 02 2021, 06:48 AM , By : Barry

why msg box is not working when i try to run a loop with VBA

will be helpful for those in need Please see below your corrected code, checking column "A" though. See comments for further details:

TAG : vba

Date : January 02 2021, 06:48 AM , By : Charan Srikakulapu

MS Access Temp tables

Any of those help You can use a compact and repair after you're finished. That clears all temporary tables.In my experience, performance tends to increase, not decrease, after a compact and repair. The process itself, however, can take a little time

TAG : vba

Date : January 02 2021, 06:48 AM , By : user6025424

How to prevent UiPath from getting stuck in Call Macro Stage?

seems to work fine There is a way to do this, let me try to present it to you:You will need 3 variables for your solution as per below:

TAG : vba

Date : January 02 2021, 06:48 AM , By : Varun Chalamgari

How do I speed up a double for loop with if in the inner loop in vba?

wish of those help I've written this code to search a match in a column of sheet "q1" with the elements of another column in sheet "Complete Car". Since I have 3000 rows to check in Complete Car and 1500 in q1 (inner loop), is there any suggestion on

TAG : vba

Date : January 02 2021, 06:48 AM , By : Hamam

How to get inner text under span id

it helps some times I am working on a vba web automation project . I have come to a point where I have to get the message displayed on the web form in excel sheet. The HTML codes of the relevent section are as follows.

TAG : vba

Date : January 02 2021, 06:48 AM , By : Tanvir Hasan

Passing argument(s) to a module private function/sub

Any of those help It is not a good idea to call private functions from outside their scope, because they are private for a reason, and the reason is not to be called from anywhere, but from the specific module in which they reside.Anyway, for any oth

TAG : vba

Date : January 02 2021, 06:48 AM , By : Dario Barrotta

VBA How to get all enum

should help you out This article Pearson Software Consulting:Enum Variable Type would have you use the underscore to define hidden Enumeration values to used in a loop like this:

TAG : vba

Date : January 02 2021, 06:48 AM , By : Enosh Zerahia

How to split a string in VBA by more than one character

may help you . In my attempt, I replace all the other characters with space before splitting on space. (So I cheat a little.)

TAG : vba

Date : January 02 2021, 06:48 AM , By : Mishty

Manipulating excel "autoshapes" with VBA

this will help I'm not quite following your larger goal, but in order to bring a shape to the front use this:

TAG : vba

Date : January 02 2021, 06:48 AM , By : user3863694

How do I pass a Range to a Sub in Word VBA?

this will help It is not allowed to call a Sub with parenthesis, except if you are using the Call statement.Hence you have to use either:

TAG : vba

Date : January 02 2021, 06:48 AM , By : user3862810

How to create an addin for PowerPoint 2003

hop of those help? Create a new module and add the below autoopen function. You would need to save the file as ppa in the addins folder.

TAG : vba

Date : January 02 2021, 06:48 AM , By : user3862523

BCC in ItemSend event in Outlook 2007 no longer works

wish of those help I inserted code in ItemSend and saved the ThisOutlookSession module. It worked once and no longer works. It was saved as VBAproject.OTM and is still there when I open the module after restarting Outlook. , use and if statement on t

TAG : vba

Date : January 02 2021, 06:48 AM , By : Adam Goldsmith

ArcObjects - enumerating feature classes and datasets within a geodatabase

I wish this helpful for you It is much faster to enumerate the names contained in a geodatabase instead of the things that the names can open. The tricky part is looping through names in a featuredataset. While IFeatureWorkspace.Open can be used to o

TAG : vba

Date : January 02 2021, 06:48 AM , By : Fairy-Wilbury

Hidden pitfalls of VBA

help you fix your problem This question is meant to augment the Hidden Features question at Hidden features of VBA , The whole language?Eh, I'll be concrete: the fact that:

TAG : vba

Date : January 02 2021, 06:48 AM , By : user3857669

Auto accept outlook VBA

I hope this helps . I have used this in the past add this sub into VBA page and the wire up your rule so that it fires when you receive it from certian senders and ita meeting invite or update.

TAG : vba

Date : January 02 2021, 06:48 AM , By : user3856283

Searching a document for multiple terms in VBA?

With these it helps I'm trying to create a macro to be used in Microsoft Word 2007 that will search a document for multiple keywords (string variables) located in an external Excel file (the reason for having it in an external file is that the terms

TAG : vba

Date : January 02 2021, 06:48 AM , By : CodingDork

How do I access the value of a textbox control on a subform where the subform itself is just a control on another subfor

seems to work fine I've just assumed responsibility for a database written ages ago in MS Access and I need to make some changes but unfortunately, even though I used to be a very experienced Access developer some time ago, I haven't really used it t

TAG : vba

Date : January 02 2021, 06:48 AM , By : user3094969

How can i change every occurence of a specific font ind a Word document?

I hope this helps . It's not clear what is meant by "textfield" as that could be any of five or six different things in Word...But there is a way to access almost everything (excluding ActiveX controls) in a Word document by looping all StoryRanges.

TAG : vba

Date : January 02 2021, 06:36 AM , By : user3094836

How to add YES/NO checkbox column to existing table using VBA?

around this issue Your SQL syntax is not correct. Once corrected, this runs smoothly and as intended here:

TAG : vba

Date : January 02 2021, 05:18 AM , By : user3093601

Is it possible to use the filename generated by previous code as the variable for next line of code?

fixed the issue. Will look into that further I have used vb to create two files that their names are based on the first line of each of their content. Now, I want the two windows to be arranged vertically and thus use the "Windows.CompareSideBySideWi

TAG : vba

Date : December 31 2020, 03:06 AM , By : malloc

Changing the ColorIndex of a DataLabel is not behaving as stated by the documentation

I wish this help you 1) I think you want Font.Color instead of ColorIndex.2) You can use the named color constants, e.g. vbRed, vbBlack, etc.

TAG : vba

Date : December 31 2020, 03:06 AM , By : user3089963

Filter SubForm based on multiple criteria

should help you out Assuming the field [User] is a String - include single quotes like this:

TAG : vba

Date : December 31 2020, 02:31 AM , By : user3089205

How to get email address with VBA based on windows login name?

I wish this help you Personally, I use the following function, though there are many possibilities.

TAG : vba

Date : December 31 2020, 02:07 AM , By : Evan

How can I make this code better / quicker?

wish helps you i have a collection of working codes, that removes words from a word table, and reformats the size of the table. I know i'm repeating, in the code, so i'd like to make this more streamlined, and in the hope that by doing this, the code

TAG : vba

Date : December 31 2020, 02:07 AM , By : user3088930

Text from listbox into array, text not making it into my array unless I click an item in the listbox first

I hope this helps . I am trying to capture the text all of the items in a listbox into an array. When I click the button to do this, it does correctly count and add the right number of items into the array but the text of the values in the listbox ge

TAG : vba

Date : December 30 2020, 04:08 PM , By : user3088358

vba standard function from an input box and show results

will help you Yes, though the messagebox will show the correct result as of this date:

TAG : vba

Date : December 28 2020, 02:06 PM , By : sharan2510

For each "group": sum the respective volume and colli count

like below fixes the issue Here's a program that should do what you're looking for. You'll need to update the sheetName variable in the main function, but other then that, it you shouldn't have to make any changes

TAG : vba

Date : December 28 2020, 05:45 AM , By : bmuldoon76

Add start and end word fields for tracked changes

around this issue In order to move out from the loop at correct time, I used the below approach. Any improvements or other answers are appreciated.

TAG : vba

Date : December 27 2020, 04:45 PM , By : user3085946

Replace text in Word VBA based on Multiple Font Conditions

hop of those help? I am trying to delete all the words with font. name.FarEast="Georgia" and font.name="Verdana", Bold=true in the document, but I cannot find any find function for vba...(I'm ok with manually set the find formating) can anyone help m

TAG : vba

Date : December 27 2020, 04:45 PM , By : user3085832

Is there a VBA event triggered when a Word document is closed?

around this issue There are two basic ways to capture when any Word document closes: Use a macro named AutoClose in any module of Normal.dotm (or any template loaded as an add-in). This is the "old-fashioned" way that comes from the WordBasic (Word 2

TAG : vba

Date : December 27 2020, 03:57 PM , By : user3084517

How to decompile a access database without starting/opening it?

hope this fix your issue Don't believe that you can de-compile without launching the application. (even from command line). The only possible approach would be to create a blank database and import everything. This I suppose could be automated, and t

TAG : vba

Date : December 27 2020, 03:09 PM , By : user3082502

Run on the master workbook, check if there are any new or deleted worksheets in the daily input workbook

I think the issue was by ths following , I am trying to figure out how to do this, any guidance would be great. , This ought to work, but I'm on my phone so can't actually check it:

TAG : vba

Date : December 27 2020, 02:58 PM , By : user3082354

Is there any C-style string formatting in VBA?

This might help you I would like to use C-style string formatting in VBA to make it easier to send SQL instructions the same way I do in Python. , You can use a System.Text.StringBuilder like this:

TAG : vba

Date : December 27 2020, 02:42 PM , By : dinhchuong7913

VBA - Overflow error if passing certain digits to another sub

like below fixes the issue You get an overflow because you have surpassed the maximum Integer value (32,767). In order to handle larger range of arguments, use Long. You can convert your Module 1 like so:

TAG : vba

Date : December 27 2020, 02:42 PM , By : Mario Martínez

Making an appointment in a public folder calender

should help you out to Dimitry i was able to find an answer to my question. First i changed olFolderCalendar to olPublicFoldersAllPublicFolders since the calendar is on the Exchange public folders store. Then i used the .Folder method to get to locat

TAG : vba

Date : December 26 2020, 02:30 AM , By : user3081653

Document Export failing in ms-project vba

wish helps you Realized I didn't have the latest office 365 build due to being on the semi-annual update channel. I switched to the monthly channel updates and the problem was fixed.

TAG : vba

Date : December 26 2020, 01:01 AM , By : user3080860

How to select record with max value and use variable to reference recordset field name?

I wish this helpful for you I need the code to execute the following logic: , Use dot (.) with Fields collection:.Fields(nameFieldSort)

TAG : vba

Date : December 25 2020, 09:30 PM , By : user3079306

Applying shading to character styles using Word VBA

Hope this helps Shading isn't a property of the style. It is a property of either the paragraph format or the font, depending on the type of style. If you don't know what type of style sStyle is you could use the following code to set the shading.

TAG : vba

Date : December 25 2020, 07:30 PM , By : user3078214

Assign Word Table Cell values to variable in Word Document

I wish did fix the issue. I am trying to create 2 variable from a string in the cell. cell string is "Mr Jonhattan Smith Sun". Value1 I want as "Jonhattan" and value2 as "Smith Sun". I have the following codes but doesn't seem to work properly. any H

TAG : vba

Date : December 25 2020, 07:30 PM , By : user3078204

Can't pull out a specific field available in every row in a table from a webpage

wish helps you I suppose there isn't any elegant way of using textContent in vba selenium bindings. However, you can go with the following approach for now.

TAG : vba

Date : December 25 2020, 05:31 PM , By : technocrat

Use VBA to check for text before taking action without selecting text

Any of those help There's actually a quite elegant and easy way to do this. Instead of using Selection do the Find using a Range. Think of a Range like an invisible selection, but with two major advantages: The selection doesn't change. Code is faste

TAG : vba

Date : December 25 2020, 05:02 PM , By : user3077145