ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Positioning a Button (https://www.excelbanter.com/excel-programming/340622-positioning-button.html)

filo666

Positioning a Button
 
Hi, I have a macro that finds the last row used and the insert a new row at
bottom of the last one and in cell a put the name of a person (userform1
askes it),in cell b the status and in cell c the amount; what I want is that
in cell d appears a button so the user could print the information of the
user in the row, I ahev everithing but how to possitioning the button exactly
in cell D
How to acomplish this???
TIa

Norman Jones

Positioning a Button
 
Hi Filo666,

Look in VBA help at the TopLeftCell and BottomCellRight properties.


---
Regards,
Norman



"filo666" wrote in message
...
Hi, I have a macro that finds the last row used and the insert a new row
at
bottom of the last one and in cell a put the name of a person (userform1
askes it),in cell b the status and in cell c the amount; what I want is
that
in cell d appears a button so the user could print the information of the
user in the row, I ahev everithing but how to possitioning the button
exactly
in cell D
How to acomplish this???
TIa





All times are GMT +1. The time now is 12:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com