Recent Activities
-
dangelor
Replied to the thread Sum columns in several sheets with VBA.PostPossibly...
(Code, 15 lines) -
dangelor
Replied to the thread fix code search by dropdown and get data from sheet to another.PostPossibly...
(Code, 31 lines) -
dangelor
Replied to the thread Private Sub Worksheet_SelectionChange vs other options.PostTry this...
(Code, 16 lines) -
AlanSidman
Replied to the thread Automatically enter data into a cell based on another's cell value.Post(Code, 15 lines) -
AlanSidman
Replied to the thread Sum columns in several sheets with VBA.PostAttach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make… -
jolivanes
Replied to the thread Transferring line-spaced information to the other page one after another.PostThanks for letting us know.
Very much appreciated.
Good Luck.
If the previous code is too slow, this should be faster.
(Code, 43 lines) -
dairyengineer
Has received the trophy Yearling.TrophyReached 1 year of membership at OzGrid -
alhagag
Replied to the thread fix code search by dropdown and get data from sheet to another.Postthanks dangelor yes this is what i'm looking for but i have last request i would when dropdown is empty so it shows all of data -
Learner.Here
Replied to the thread Private Sub Worksheet_SelectionChange vs other options.Post(Quote from dangelor)
(Quote from Learner.Here)
Namastey dangelor,
As I was trying the run the given sequence of codes, I ran into an issue.
I noticed you had not set the PW Lock at the end of Change event, and when I set the PW Lock On, it would run into… -
VWRSue
Posted the thread Automatically enter data into a cell based on another's cell value.ThreadHello. I would like Excel enter data from one cell into another cell, based on another cell's entry. For example, I have a date in column A, in column B, there will either be a date entered, or n/a. If column B is n/a, then I would like Excel to take… -
Roger 5678
Has received the trophy Yearling.TrophyReached 1 year of membership at OzGrid -
[email protected]
Replied to the thread User input to select a specific sheet upon opening.PostYou mean I could hide all the sheets not selected? -
royUK
Replied to the thread Handling blank RedEdits.PostPleased to help -
Learner.Here
Replied to the thread Private Sub Worksheet_SelectionChange vs other options.Post(Quote from dangelor)
Thank you for the tips! Will follow these! -
Learner.Here
Liked dangelor’s post in the thread Private Sub Worksheet_SelectionChange vs other options.Like (Post)Wise Owl Tutorials on YouTube
ExcelMacroMastery.com -
nzso
Replied to the thread Preventing ComboBox from Activating when Not in Use.Post@ Rory
- Professional Plus 2019.
-
rory
Replied to the thread Preventing ComboBox from Activating when Not in Use.PostCurious. What version of Excel are you using? -
nzso
Replied to the thread Preventing ComboBox from Activating when Not in Use.Post@ Rory
Yeah... Same issue... Neither does it pick anything from the Drop down Narrowing it down, stays same for a while and then the error pops-up. -
rory
Replied to the thread Preventing ComboBox from Activating when Not in Use.PostWith this file?
