Questions tagged as 'vba'

Tagged questions
1
answer

VBA - Delete only last row of the table that contains a text

I have a somewhat specific question. I hope you can help me I have a worksheet that contains a table called "Activities". I have some form controls to fill in the same but I came up with the need to insert and delete rows from this table with...
asked by 05.09.2018 / 00:10
2
answers

How do I copy the value of the expecific textbox of the Open UserFom?

It has an easier way than typing x = UserForm1.textbox2.value ? This statement means: Copy the value of the UserForm1 text box1 . I wanted to replace the "UserForm1" statement with something that means "Open UserForm." that is:...
asked by 31.08.2018 / 17:16
1
answer

How do I open a UserForm with the same name as a button? VBA language

My program consists of 20 buttons and 20 UserForms. I wanted to simplify the program and make a unique Sub Routine. Each time I press a button, the CheckBoxPreview routine analyzes the button name and opens the UserForm with the same button n...
asked by 29.08.2018 / 14:06
1
answer

Error 381 listbox.list VBA

Hello! Basically I need to add the values from the listbox, but my program is displaying the following error. Run-time error '381': The List property could not be obtained. Invalid property array index. Private Sub TextBox1_AfterUpdate() D...
asked by 08.09.2018 / 00:55
0
answers

Search for image from a list

Hello, I have a list of approximately 1,000 products, the first column is the sku code and the second is the name. I need the image of these products that are easily found in Google by sku code. Is there a way to automatically fetch these images...
asked by 17.08.2018 / 23:36
0
answers

Fill combobox on WEB page via VBA

I'm trying through VBA in Excel, filling a combobox on an internet page. But when I run the code, that error message appears saying that "The object does not accept this property or method" . Part of the HTML code for the webpage is this:...
asked by 25.08.2018 / 18:46
1
answer

MessageBox in VBA in Excel

Hi, I'm working on a PivotTable in Excel and I would like it when I typed the text store 10, it would display a warning that this store is unavailable, I know I need to call a messagebox however I have no idea what other structure need to use, c...
asked by 23.08.2018 / 20:27
1
answer

Block printing via menu "Print" with macro

I wonder if there is any way to block the printing of a worksheet from the File-Print (Ctrl + P) menu or the printer icon through a macro. Well, I made a macro that when you push a button it will do a behavior in the worksheet and have it printe...
asked by 18.08.2018 / 01:55
1
answer

Zero Page with every click

I have in the figure above this small UserForm with three pages. On the first page, when you click the Enable button, the next date is inserted with TextBox Data as False, so the user does not change. The Enable button also enables the Predic...
asked by 06.08.2018 / 19:02
1
answer

Effect "Fade in and Delete - VBA"

I am having a question in VBA - MS EXCEL 2016 I need to create a macro that when I trigger it, it searches for an image.png on my computer and inserts it on the worksheet with the gradual effect of Fade-in. After that, the image should appear...
asked by 12.08.2018 / 04:51