Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Sep 15, 2025
Topics: 61 / Replies: 1581
Reply
Reply
Reply
RE: I want to access a website using VBA codes by entering auto login credentials after that i want to go particular page, Please help me

Hi, I find using SeleniumBasic much easier than using IE. This post walks you through setting it up and how to interact with the website form. ...

6 years ago
Forum
Reply
RE: Pointing to appropriate cells via formula with variables

Hi Roanne, I've modified the formula in Col J to include a VLOOKUP of some different types, as Mynda described. You can expand the lookup range VL...

6 years ago
Reply
RE: Dynamic drop lists

Hi Stefi, Creating a name for each column is the way to do it. Try these articles Regards Phil

6 years ago
Reply
RE: Search string for word from a list

Hi Roxanne, Please start a new topic when you have anew qs, rather than add to an existing topic on a different subject. I've moved this post here...

6 years ago
Topic
Reply
RE: Table Auto Insert New Row with Formula After Hit Enter

Hi, You could just use TAB to move through each column and a new row will be added once you tab out of the last column? Why are you using NOW() ...

6 years ago
Forum
Reply
RE: Simple Copy and Paste Formula-Only Code

Hi Paul, You can use this Range("B2").Copy Range("B1").PasteSpecial xlPasteFormulas Application.CutCopyMode = False Regards Phil

6 years ago
Forum
Reply
RE: Barcode ID split into few textbox in userform VBA

Hi Mariya, Please see attached. Splitting up the code is pretty straightforward using VBA string functions You could also read my Excel Forms p...

6 years ago
Forum
Reply
RE: Categories distribution

Hi Bill, No file attached. regards Phil

6 years ago
Forum
Reply
RE: Copy cells with consecutive references

Hi Herman, Please supply your workbook with the data laid out as you will use it, and as you expect it to look in the end result. Giving you an an...

6 years ago
Reply
RE: Barcode ID split into few textbox in userform VBA

Hi Mariya, Can you please supply your workbook and code otherwise anything we write will have to be rewritten to suit your environment. Thx P...

6 years ago
Forum
Page 87 / 110