vba tag

72 questions

1 answers
294 views
0

Excel VBA Other Sheets Not Reflected

What I want to solveExcel VBA Does Not Reflect Data Extracted from Other SheetsProblems and Errors OccurredI would like to extract the data of Excel sheet from other sheets, but the data using '=' is ...

vba excel

1 years ago

1 answers
438 views
0

VBA 2-DIMENSIONAL DYNAMIC JAG ARRANGEMENT

Purpose: I want to create a 2D dynamic jug arrayI want to expand only the second dimension laterWe decided to declare a one-dimensional array in variant form and store it in it again.I tried three met...

vba array

1 years ago

1 answers
340 views
0

I want to automatically divide the string entered in one cell with different colors in Excel and replace it with a new cell.

How can I automatically divide a string entered in one cell with different colors in Excel and replace it with a cell?For example, Cell [A1] Ah (black) Good (blue) U (black) and what is entered in the...

vba excel

1 years ago

1 answers
333 views
0

Understanding Retrieving and Storing VBA Values in an Array

The following code is used to store cell values in an array, but when I checked Debug.Printary(j,1), it seems that the values are not displayed (not retrieved).ary=Array (Cells(j, E).Value, Cells(j, F...

vba

2 years ago

1 answers
310 views
0

How to Pass UserFrom1 Variables to UserFrom Form 2

When I click CommandButton1 in UserFrom1, I put 10 in variable A (variable A is public variable). What code would it be to display UserFrom2 in UserFrom2.Show and MsgBox in UserFrom2 to display the co...

vba

2 years ago

1 answers
357 views
0

code that retrieves all values in a folder

How do I get all the values in the folder?The macro below will only get the first value of the book.I'd like to transfer all the values I got, so please tell me how to do it.Sub-Single Test Specificat...

vba

2 years ago

1 answers
528 views
0

When translating using DeepL in Excel macros, I want to translate English sentences as a whole in the cell, not as a period.

As the title suggests, I would like to get the entire English sentence from the cell because the sentence is entered into DeepL with a period break, or just one sentence. I have changed the sentence. ...

vba natural-language-processing

2 years ago

1 answers
268 views
0

Is it treated as an escaped name if the member name is enclosed in square brackets ([]) in the Enum statement of the VBA?Is it better not to use this technique?

The following code is executable.　About 10 years ago, when I just started studying VBA, like other languages I had experienced (C#, VB.net), This is ToString(), which I worked hard to get the Enum mem...

vba

2 years ago

1 answers
454 views
0

I want to use ExcelVBA to search for words in newspaper PDF data, and if it hits, I want to extract PDF data that hits the search word into Excel.

I use Acrobat Reader Pro to write in VBA, but it doesn't work.I tried to extract the PDF to Excel after XML conversion, but I couldn't because the XML file didn't translate the contents of the newspap...

vba pdf

2 years ago

2 answers
399 views
0

I want to get my PC session ID in VBA

I want Excel VBA to be able to code for the session number that I can get from the command prompt in query session. How can I do that?I looked at another site and tried to retrieve it using Shell, but...

windows vba session

2 years ago

- 1 -

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656