The 30 million medical ward block has replaced the Victorian Vickers Corridor wards at the hospital and has been designed to provide modern NHS care.
During his visit on Thursday October 11 the Duke will tour the 168-bed unit, meet patients and staff and unveil a plaque.
David Stone, chairman of Sheffield Teaching Hospitals NHS Foundation Trust, which manages the Northern General and other city hospitals, said: “We are very honoured that the Duke of Kent is to officially open the new Sir Robert Hadfield Wing in October.
“The wing is enabling us to provide the very best in NHS facilities for the people of Sheffield and is a building that the city can be proud of for years to come.”
On the same day the Duke will also visit B Braun Medical, at Thorncliffe Park, Chapeltown to hear about their work with the NHS to improve hospital hygiene and develop technology to help patients with heart and knee problems.
He will also visit the University of Sheffield in Western Bank.