hi,
i want to add data validation for inputbox,
i want inputbox value should not be greater then range("b3").value
thank you
hi,
i want to add data validation for inputbox,
i want inputbox value should not be greater then range("b3").value
thank you
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
Just test the value returned by the InputBox and then react accordingly. You can't actually add validation to the inputbox itself, other than basic type validation (numbers, ranges, text) if using Application.Inputbox.
Don
Please remember to mark your thread 'Solved' when appropriate.
Typically you check after value is entered before you proceed with rest of the code.
Either, Exit Sub if invalid or use GoTo statement to bring them back to input box.
Please Login or Register to view this content.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Super Perfect
CK76
Its working as i need,,,
and thank you xlnitwit
You are welcome, and thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks