excel macro vb coding

Hi, I am new to macros. I am writing my first code to fill some fields in web page and save it. The page is having few tabs, on clicking the tabs fields will be displayed on some part of same page for the corresponding tabs, where i am trying to fill the data. Below is the html code for one of...

I have a module that is working but when it ends, instead of staying on the spreadsheet, it goes back to the VB code, what am I doing wrong below: Sub UserInput() Dim iReply As Integer Dim Response As Variant Dim iNum As Integer ActiveSheet.Unprotect "XXXXX" iReply = MsgBox(Prompt:="Do...

hi i need a vb macro formula to run in macro to put inverted comma start and end of sentence in the fiels like "i am good in macro excel" in cell c9 and c16 cell

Hello, I'm trying to automatize a report. I have several huge formulas that I would like to embed into the VBA editor. Can anyone help? This is the formula I want the Macro to enter: <tbody> IFERROR(IF(IF(ISNA(VLOOKUP(A:A,'Q1186 Warehouse Order Roundup'!A:S,MATCH("SHIP_STATUS",'Q1186...

Dear Experts, I intend to re-arrange the data generated by system. I am using Office 2010 Current Format: Mat No Cost1 Cost2 Cost3 A 5 3 2 B 6 9 3 C 7 6 2 To be Format: Mat No A 5...

<TBODY> 1. i want to Create a border around items with row 1(name) (do not look at size-number after last dash) and same item title.how please write code if cell <TBODY> 2. Highlght in yellow group of items (row1+ row2) where some status is 100% not linked and available of atleast 1 row is >0...