Questions tagged as 'excel-vba'

Tagged questions
1
answer

How to convert Pounds into Euros VBA?

CONVERSION: The conversion will be the value in Pounds x 1.17 = Amount in Euros. To be able to add a percentage the formula will be Pounds x 1.17x (1 + percentage). METHOD APPLIED: Substitution of the column of pounds 200% with% 50 to 250%...
asked by 01.06.2017 / 12:35
1
answer

Define the color of a series in a new chart in the worksheet

In VBAProject I have a row that selects a particular chart series Sub MudaCor() ActiveChart.SeriesCollection(n).Select End Sub Being "n" the serial number I need to select. The colors of the series of a chart, whether of bars or even row...
asked by 16.05.2017 / 15:59
1
answer

Excel stops working when I use workbook.close to close another worksheet

Thank you in advance for trying to help me. I have a somewhat complex programming where I use a file to initialize 2 macros into other files. At the moment of closing the files, I open a txt file in excel, paste the contents of my spreadsh...
asked by 19.06.2017 / 17:26
1
answer

Check if an item in a ListBox has been selected

I have a ListBox1 q list of a ChckBox1 checkbox in a UserForm. I want to enable or disable the checkbox ( CheckBox1.Enabled = True/False if any items in the list are selected. The checkbox is disabled initially, but if so...
asked by 27.04.2017 / 22:11
2
answers

Separate fixed headphones from furniture to add ninth digit

I have a spreadsheet with almost 60 thousand lines, with 3 columns: Contact Us | Phone 1 | Phone 2 In both handset columns I have fixed and mobile numbers and for me the logic is simple: Fixed handset is a number that is less than 8 digits. I...
asked by 11.12.2017 / 16:02
1
answer

How to make a print in VBA

I have an excel full of information But I want to separate the information Imagining what I have in a cell A-ABC-DEF How can I get ABC to appear through a formula in VBA     
asked by 21.09.2018 / 12:43
2
answers

Excel form (Block fields)

I have a question as to which formula I can use. I have a box with 3 options (Example: 1, 2, 3) and if I select the option 1 I can fill in the field 1 and the > options 2 and 3 . If you select option 2 , I can fill in the field 2 an...
asked by 21.12.2017 / 13:13
1
answer

Excel change only part of a cell text

In an excel document I want a given text in a cell to automatically enumerate when I copy the entire group of cells. Example of explanation. - What I want is to copy the entire text and just modify the cell that says "text, 50, Num" so that it i...
asked by 17.08.2017 / 15:12
1
answer

Automation Development in VBA - Error Handling in Loop

I'm developing a VBA automation that accesses a certain site and takes some information from it, but I'm having a problem with it. The site (Santander - Benner) is very badly done, many parts were built in a way that seems to mend with what t...
asked by 19.06.2018 / 15:15
1
answer

do research on two worksheets with a form in the vba

Good afternoon people! my problem is the following: I have a form with 2 textbox one for students name and one for room and a spreadsheet with two tabs with the same names (txtAlomeAlunos, txtSalaAlunosplan1-name, plan2-sala) I would like to kno...
asked by 27.09.2018 / 17:13