Recent questions tagged VBA

0 votes

781 views

1 answer

vba - How to break long string to multiple lines

I'm using this insert statement in my code in vba excel but i'm not able to break it into more than one ... end of statement". Plz help. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

860 views

1 answer

vba - Number of Google Results from Excel

Given a column of strings in Excel, is there an easy way to return the number of results from a Google ... Excel into Google search results. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

967 views

1 answer

vba - How to check whether Connection Refresh was successful

In Excel 2016 VBA, I'm refreshing several queries like this: MyWorkbook.Connections(MyConnectionName).Refresh After ... a SQL server database. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

727 views

1 answer

vba - How to open a URL from MS Access with parameters

I have a basic MS Access application that has a button on a form that should open a webpage with the ID of the ... on the end of the URL. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

662 views

1 answer

vba - Sending Excel file, that contains the code, as an attachment

I've written Excel VBA code that sends an email via Outlook. Everywhere I've looked, example code for ... objOutlook = Nothing End Sub See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

869 views

1 answer

vba - fast way to copy formatting in excel

I have two bits of code. First a standard copy paste from cell A to cell B Sheets(sheet_).Cells ... ) 'Application.CutCopyMode = False See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

744 views

1 answer

vba - Excel Worksheet_Change Event not working

I am trying to write a macro where changing any column should automatically save worksheet. My Excel sheet expands ... Any help is appreciated. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

vba - insert full ADO Recordset into existing ACCESS table WITHOUT LOOP

I have a filled ADO recordset in my VBA module. I also have a table in ACCESS that has exactly the ... : would this be significantly faster) See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

742 views

1 answer

vba - Pass array to ParamArray

is it possible to pass all elements of an array to a ParamArray? For example I'd like to pass a ParamArray ... in VBA. Thanks for help, Michael See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

804 views

1 answer

vba - vb macro string width in pixel

How would you calculate the number of pixels for a String (in an arbitrary font), using an Excel VBA macro? ... com/forum/showthread.php?t=94339 See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

618 views

1 answer

vba - Running multiple async queries with ADODB - callbacks not always firing

I have an Excel workbook that fires three queries to a database to populate three tables on hidden sheets, and ... 's a better solution first. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

752 views

1 answer

vba - "Do While" "Loop" and "While" "Wend" Loop. What's the difference?

Reading some answers in stackoverflow I saw a while wend loop. I'm used to the do while loop, so I was wondering what ... i = i + 1 Wend End Sub See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

519 views

1 answer

vba - Writing an array to a range. Only getting first value of array

I am trying to write an array to a range and I have tried several ways but no matter what, I always get ... helps someone else down the road. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

846 views

1 answer

vba - How do I test if optional arguments are supplied or not?

How do I test if optional arguments are supplied or not? -- in VB6 / VBA Function func (Optional ByRef arg As ... "NOT SENT" End If End Function See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

771 views

1 answer

vba - Detecting Outlook autoreply/out-of-office emails

Been googling for this and haven't found anything ... Does anybody know if there is a way, given an ... me Outlook is the highest priority. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

729 views

1 answer

vba - Excel 2010: how to use autocomplete in validation list

I'm using a large validation list on which a couple of vlookup() functions depend. This list is getting larger and ... . Hope you guys can help. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

839 views

1 answer

vba - Excel macro formula adding quotes in formula causing vlookup to not work

I am trying to add a formula to a cell. The macro is adding quotations around the cell range, which causes the ... around the cell A7 and D30. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

688 views

1 answer

vba - code to delete the row if the cells on specific column are unique

What I am trying to achieve is to create a vba code to completely delete the rows if the value in column C (Id) is ... i + 1 End If Loop End Sub See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

734 views

1 answer

vba - Can AutoFilter take both inclusive and non-inclusive wildcards from Dictionary keys?

I have been looking for a way to filter an Excel spreadsheet with more than two wildcards. I asked on ... Set dVALs = Nothing End Function See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

917 views

1 answer

vba - How do I show a running clock in Excel?

I'd like to show a clock in cell A1 of Excel 2007. I'm familiar with NOW() and TODAY() but it doesn't ... Activity X, Y, and Z. Thanks SO. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

624 views

1 answer

vba - every possible combination of the contents of 2 columns in excel

Suppose I have 2 Columns: 1st column(contains 1000 rows): U-0001 U-0002 2nd column(contains 10 rows): B01 B02 B03 ... B01 U-0002 B02 U-0002 B03 See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

669 views

1 answer

vba - Loop for all worksheet in a workbook is not working

I would to copy paste the first cell of a sheet trough the last row for all sheets in a workbook and my code ... ws End Sub Thanks for your help See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

797 views

1 answer

vba - Refresh all charts without blinking

The aim is to refresh all charts in Excel after cells recalculation. I work with Microsoft Excel 2010. As we ... do I miss something important? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

931 views

1 answer

vba - SpecialCells(xlCellTypeVisible) not working in UDF

Based on the question posed by @Chips Ahoy, I decided to create a UDF to find the PercentRank of visible cells in ... .5): $A$2:$A$41 $A$2:$A$41 See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

852 views

1 answer

vba - Create event handlers for multiple dynamic controls

I have a userform that creates two dynamic control buttons but I am having difficulty accessing the .name property ... access the first button? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

770 views

1 answer

vba - Copy Non Blank Cells From Range to Range

I wonder if you can help me with this: Ranges B11:B251 & C11:C251 may or may not have some values. I want ... clear? ;-) Thanks for any replies! See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

847 views

1 answer

vba - Joining a range of cells in excel using &

I know I can concatenate a set of cells using & like this: A1 & B1 & C1 & D1. Is there a way to write this for a range A1:P1 using & ? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

908 views

1 answer

vba - Creating a "Check Names" button in Excel

I am new to using VBA and Macros and am wondering if there is a way to add a "check names" ... right direction would be greatly appreciated! See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags